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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a fill factor?

885


What are diverse clauses that form a part of sql?

844


what is create database syntax? : Sql server database administration

841


Why and when do stored procedure recompile?

761


How would we use distinct statement? What is its use?

838


what is the information that can be stored inside a bit column? : Sql server database administration

754


Explain what are magic tables in sql server?

764


what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

762


Do you know what are different types of replication in sql server?

790


Explain differences between web edition and business edition?

117


What is after dml trigger?

814


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

742


explain different types of cursors? : Sql server database administration

806


Tell me what are the advantages of using stored procedures?

795


What are cursors and when they are useful?

800