Constraints on the whole table in SQL Server

Venkatesan Jayakantham
13y
3.4k
0
0

Blog

One of my blog reader have asked me a query, Is it possible to give constraints to all the columns in a table in a single shot?

 

CREATE TABLE 
dbo.Venkat_Table



(

   id 
int primary key,

   
Name varchar(50) unique,

   Age 
int Unique

)

Yes it's possible. We can provide the constraints.
Applying terms and conditions -> The constraints should not conflict with one another. Primary key constraints can be given only once for a table.

Cheers,

Venkatesan Prabu .J
Head - WWW.Kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/