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

Answer Posted / shelly

Constraints are used to limit the type of data that goes
into a table.Constraints can be declared at the time of
creating a table or by altering the already created table.

1)Not Null
2)Unique
3)Primary Key
4)Check
5)References
6)Default

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Introduction of rollup clause using sum and group by clause?

712


What are the diifferences between the ms sql server vs mysql?

896


What is difference between clustered index and non clustered index?

803


What are the requirements to use odbc connections in php scripts?

820


What is collation sensitivity? Explain different types.

727


What is difference between drop truncate and delete?

750


How to backup SQL Server Reporting Services ?

122


What is raid and what are different types of raid levels?

790


What are the database objects? : SQL Server Architecture

708


Difference between report and query parameter. Why do we need different type of parameter?

748


What is difference between primary key and foreign key?

653


Tell me what is normalization? Explain different forms of normalization?

774


What is tabulation?

709


What is the primary use of the model database?

798


Describe how to use the linked server?

812