Change column value in Firebird

0

I have a table with approximately 7 thousand records, I need to create a new column in this table but I would like all the old records to have the value 'S', when I try to create the column the fields get null value, passing as default ' S'. How can I make this change in my table?

    
asked by anonymous 07.12.2017 / 12:19

1 answer

3

To include your column, you can give a update in your table for cases where your field is null .

update tabela
set campo = 'S'
where campo is null
    
07.12.2017 / 12:21