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

Answer Posted / lekhraj

Constraints are the way by Databse managing the data inegrity.

Types of constraint are:-
1)NOT Null
2)Default
3)Check
4)Rule
5)Primary
6)Unique
7)Foreign

Is This Answer Correct ?    46 Yes 65 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what are pages and extents? : SQL Server Architecture

751


What command do we use to rename a database?

787


Do you know what are the restrictions that views have to follow?

830


What is a fan-out query in SQL Azure?

115


What does it mean to normalize data?

679


How to encrypt Strored Procedure in SQL SERVER?

790


What is xdr?

763


What is dbcc? Give few examples.

761


Explain acid?

814


What is an expensive query?

715


What is the native system stored procedure to execute a command against all databases?

726


how you can get the list of largest tables in a database? : Sql server administration

739


How to reaname table name without using sp_Rename in sql server..?

739


Why we use the openxml clause?

736


Explain what are the events recorded in a transaction log?

743