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

Answer Posted / srinivas

Constraint are the rules enforced on data columns on table



Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

Is This Answer Correct ?    28 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is stored in the mssqlsystemresource database? : sql server database administration

815


What is clustered primary key?

783


How to convert numeric expression data types by assignment operations?

759


How to maintain a fill factor in existing indexes?

746


How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

838


What are the different types of lock modes in sql server 2000?

661


Mention the differences between sql server and mysql.

710


How to call a function from a stored procedure in SQL Server ?

764


What is transaction server consistency?

757


How to rename databases in ms sql server?

870


How to change the name of a database user?

759


What are the different types of collation sensitivity in sql server?

803


how can u get last observation in an unknown dataset ?

2210


What are the tables in sql?

816


Do you know what is a linked server in sql server?

735