How to define constraints in create table statement

[ZAMBER25]

Hi experts. Could any one tell me how we can define constraints in create table statements? Furthermore, how many type of constraints we ca defind in create table statement.An exmaple in sql server 2k will highly be appretiated.Thanks

 

[jbenson001]

Check Books On Line, there will be examples there.

 

[NoCoolHandle]

yes, all and
create table abc (c1 int identity primary key, c2 varchar(300) default 'no value' not null,
c3 varchar(300)check (c3='Only Answer Possible look up Create Table in BOL for wildcard examples ' )