Table Scripts - Do Not Contain Default Values ?? 1

[JohnBates]

Hi,

This is SQL 2000 SP 3a

When I script a table - - in Enter Mgr - right click --> Create Script....

The script doesn't reflect default values so I then have to put those in manually after running the script.

Is there a way to capture defaults in the script?

Thanks, John

 

[nigelrivett]

On the options tab there is an option to script defults - with PKs and FKs ...

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[JohnBates]

well, duh ! I should have explored those options before submitting a question.

Thanks, John