Default value for default constraints 1

[mreigler]

I'm trying to programmatically script out the default constraints from tables in one database to update copies of those tables in another database. I have the table name, column name, and constraint name from syscolumns and sysconstraints, but I haven't been able to find where the default value is stored.


Mike Reigler
Melange Computer Services, Inc

 

[vongrunt]

Table syscomments - [text] holds default's code, id/colid are keys to join.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[RAS56]

I have found the following help file to be helpful when trying to extract information from the server configuration tables.

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

It also comes on the CD with the SQL Server 2000 Resource Kit.

I haven't located a similar resource in SQL Server 2005 yet. Perhaps someone here can elaborate on whether something like that exists for SQL2005 or how much difference there would be between these structures in 2K and 2005 versions.

 

[mreigler]

Thanks vongrunt, that did it.

Mike Reigler
Melange Computer Services, Inc

 

[vongrunt]

System tables in SQL2005 are radically changed, information_schema views are still there.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]