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

What are constraints? Explain different types of
constraints?

Question Posted / manish nagar

26 Answers
138616 Views
Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
E-Mail Answers

Answer Posted / manish nagar

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

Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Is This Answer Correct ?

12 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is model database in sql server?

1010

What stored by the tempdb ? : sql server database administration

1015

What is transact-sql ddl trigger?

1058

Do you know what is xpath?

1013

Do you think BCNF is better than 2NF & 3NF? Why?

1235

What are scalar functions?

958

Describe in brief databases and sql server databases architecture.

955

What are the advantages to use stored procedures?

1045

Explain what are the authentication modes in sql server?

960

Is foreign key unique?

961

Can we install sql server 2016 on windows 7?

1082

what's new in sql server 2016?

914

what are constraints? : Sql server database administration

993

System variable and temporary variables

2189

Explain about the command-line tool SQLCMD?

1033