Constraint are used to table columns validations. there are some constrai

what is Constraint? How many types of constraints in SQL ?

Question Posted / shankar k

Answer Posted / shankar k

Constraint are used to table columns validations.
there are some constraints.

Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default

Is This Answer Correct ?

43 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Explain primary key?

908

What is wrong with sql server client libarary dll, ntwdblib.dll?

1003

What is inline table-value user-defined function?

1031

Explain partitioned view?

1032

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

931

What is the difference between ddl and dml?

1009

How do I delete a sql server database?

994

What are the benefits of normalization?

1054

How do you identify a foreign key?

983

How many non clustered indexes there can be on table ?

867

Explain the difference between functions and stored procedures in sql server?

932

What are the lambda triggers?

865

How do I find the default sql server instance?

911

Can we perform backup restore operation on tempdb?

965

How many databases Microsoft SQL server provides?

1033