Default field values

[skalyanaraman]

Hi,
When creating tables can we specify a field to have a default value like we do in Oracle or Sqlserver? If possible, can we change the structure of the table to have the defaule value later by issuing an alter table statement?

Thanks!!

[John]

You can not specify a default value for a field. You would need to insert the value you want.