Constraint are the rules enforced on data columns on table

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

Question Posted / srinivas

Answer Posted / srinivas

Constraint are the rules enforced on data columns on table

Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

Is This Answer Correct ?

28 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is after dml trigger?

967

Explain various data region available in ssrs with their use?

885

What are the requirements for sql server 2016?

855

What does the not null constraint do?

1012

What is the default value of an integer data type in sql server 2005?

916

List the types of recovery model available in sql server?

884

Can we return Data from 4(more than 1) tables in stored procedure?

1011

What is tabulation?

902

What does set rowcount do?

871

What are the types of indexes?

1037

How do I find the sql server database version?

952

What do you understand by mirroring?

957

What is attribute? : sql server analysis services, ssas

983

What do you understand by a view?

944

What are recommended options to be used while using db mirroring? : sql server database administration

1083