Constraints are used to limit the type of data that can go into a table.

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

Question Posted / scornguy

Answer Posted / scornguy

Constraints are used to limit the type of data that can go
into a table.

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Is This Answer Correct ?

225 Yes

29 No

Please Help Members By Posting Answers For Below Questions

What is the Main Difference between ACCESS and SQL SERVER?

1065

How do I find the default sql server instance?

902

Explain multiserver query

961

How to rebuild the master database?

1011

What is difference between table aliases and column aliases? Do they affect performance?

909

What are difference between Cluster index and Non-Cluster index?

1019

What are the restrictions applicable while creating views? : SQL Server Architecture

978

Which joins are sql server default?

936

What is a constant or literal in ms sql server?

991

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

Can we insert data into view sql server?

883

What are the authentication modes in sql server? How can it be changed?

1054

How to handle error or exception in sql?

935

How to rename an existing column with sql server management studio?

948

How can sql server instances be hidden?

893