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

ow to bring suspect mode datbase online from scratch

1603


What is the difference between a "where" clause and a "having" clause?

872


What is a constant or literal in ms sql server?

821


Can primary key be a foreign key?

803


What is default constraint?

748


Explain about protocol layer present in SQL server?

817


Where are full-text indexes stored?

754


What are sparse columns?

762


What is measure group, measure? : sql server analysis services, ssas

796


Tell me what are the essential components of sql server service broker?

717


In what version of sql server were synonyms released?

722


How to stop log file growing too big?

786


Explain different types of lock modes in sql server 2000?

715


What is model database? : SQL Server Architecture

817


How is foreign key related to primary key?

744