Constraint are the rules enforced on data columns on table. Five type of

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

Question Posted / mudit

Answer Posted / mudit

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 ?

338 Yes

56 No

Please Help Members By Posting Answers For Below Questions

What is nonclustered index on computed columns?

910

why would you use sql agent? : Sql server database administration

1126

Explain about system stored procedure?

981

How do you migrate data from mssql server to azure?

165

Does a specific recovery model need to be used for a replicated database? : sql server replication

925

What is the bookmark lookup and rid lookup?

963

How to change the ownership of a schema in ms sql server?

1103

How can I create a report based on a query? : sql server management studio

978

How is foreign key related to primary key?

923

How to get a list all databases on the sql server?

1035

What is a derived table?

878

Explain what is it unwise to create wide clustered index keys?

935

How do I open port 1433?

888

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5875

What are statistics?

959