Default values

[mukund]

Hi,
When I am generating a script for table schemas and using that script to transfer tables from one database to another, the default values set for the columns in these tables are not tranferred to the target database.
Anybody has a solution for this. I had checked the Table Scripting Option
"Script PRIMARY keys, FOREIGN keys, Defaults and Check Constraints"

Any suggestions/help is welcome.

Mukund.

 

[RickCole]

I have no problems with this on SQL 7.0 and scrpting via Enterprise Manager. Are you using this method??

Run sp_help on one of your tables in question and check out the constraint_type results. If defaults are listed here then they should be also be in your script.

Rick.