check/default constraint

Anything that doesn't fall into the defect or enhancement categories

check/default constraint

Postby Wenbiao.Liang on Thu Apr 03, 2008 9:34 pm

Hi Guys,
I am trying to generate the Create Table statements from a SQL 2005 database using MyGeneration. Everything works fine, execpt I don't know how to get the default or check constraint for a column.

For example, if I have a column and MS SQL Server Management studio can generate the create statements for this column as:

[ConcurrencyId] [int] NOT NULL CONSTRAINT [DF_AttributeDataType_ConcurrencyId] DEFAULT ((0)),

How do I get the \"CONSTRAINT [DF_AttributeDataType_ConcurrencyId] \" part?

Thanks!
Wenbiao
Wenbiao.Liang
Lurker
 
Posts: 1
Joined: Wed Mar 19, 2008 10:21 pm

Return to General Questions or Comments

Who is online

Users browsing this forum: No registered users and 1 guest

cron