What are constraints? Explain different types of
constraints?

Answer Posted / satyanarayana

Constraints are the constraints which can provide on the
column data.The types of constraints are
1).Domain Integrity constraints
EX:Check
2).Entity Integrity constraints
Ex:Unique,Primary key
3).Referential Integrity constraints
EX:Foreignkey

Is This Answer Correct ?    136 Yes 41 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps you must follow to hide sql server instances?

611


What is openrowset sql server?

651


How to create a Master database in SQL server ?

641


What is use of attributehierarchyenabled? : sql server analysis services, ssas

697


Explain Reporting Life Cycle?

94






What are transactions and its controls?

702


What is the difference between ‘having’ clause and a ‘where’ clause?

651


What is a covered index?

601


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

647


What are the steps to follow to configure SQL*Net?

654


What are various limitations of the views?

703


Explain about remote stored procedure?

671


Explain activity monitors

706


What are the advantages of mirroring?

651


What are the tools available in market as an alternative to sql server reporting services?

98