I am learning to remove and add select database objects to a SQL Server 7 databse.

Using the Generate SQL Scripts tool in Enterprise Manager i create a CREATE script for a table that has 6 fields which have defaults. The script generated will only create one of the 6 default values. Why is the Scripts tool creating incomplete scripts?

I have also noticed that the scripts tool will not generate the complete script for creating all the keys and contraints of a given table. Why is the scripts tool selectively not doing this?

Thank you!

Llyal