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

Answer Posted / kumari

Constraint are the rules enforced on data columns on table

types of constraints:

PRIMARYKEY
FOREIGN KEY
NOT NULL
UNIQUE KEY
CHECK
DEFAULT
Check

Is This Answer Correct ?    111 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of “join” in sql server?

803


How do I get Report Builder to generate a parameter that can be set by users viewing the report?

124


What are the components of dbms?

739


Explain a join?

802


Can two different columns be merged into single column? Show practically?

852


What is difference statement and preparedstatement?

744


Explain different types of Normalization.

1304


What are the types of subscriptions in SQL Server replication?

764


what data regions are and what are the different data regions?

117


What are various ways to enhance the ssrs report?

758


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

103


What is the difference between deallocate cursor and close cursor?

944


Explain query editor regions

824


What is bcnf normalization form?

870


What to perform pattern match with the like operator?

686