Default value of field

[pwinstanley]

Hi there,

I need a quick answer on this as I am supposed to provide the solution today.

Is there anyway on the design view in Enterprise Manager to specify the default value for a field.

We have added new fields to the database and I want a competition field's default value to be Competition or something like that.

Any help would be most appreciated
Paul

 

[schu]

I am using SQl 2000 and it has the default value in the table design window (the attributes at the bottom)

Also you can set defaults, using database->dbname->defaults

define your defaults and then bind you defaults to a table column.

I cannot remember but i think SQL 7 has this feature as well, but not too sure about previous version.

 

[pwinstanley]

Nice one - thanks