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

Do you know the different ddl commands in sql?

1041

Write a code to select distinct records without using the DISTINCT keyword.

1107

What are the new features in sql server 2016?

964

What are the different types of replication are there in sql server 2000?

1031

What is sql profiler. What are the default templates with it? : sql server database administration

1023

How many replicas are maintained for each sql azure db?

124

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

898

In what sequence sql statement is processed?

1001

Which is faster statement or preparedstatement?

932

What command do we use to rename a database?

1070

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2739

How do clustered indexes store data?

1093

How to set a database state to offline in ms sql server?

1035

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1053

How to transfer a table from one schema to another?

993