What are constraints? Explain different types of
constraints?

Answer Posted / smita

Constraint mostly restrict the user from entering violated
data into the table..

Various types of constraints are:
Primary Key Constraint
Foreign Key Constraint
Unique key Constraint
Check Constraint
NOT NULL Constraint

Is This Answer Correct ?    44 Yes 23 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the etl (extraction, transformation, and loading)?

558


What are the reporting services components?

92


How can you manage sql azure security?

85


What is the difference between having clause and where clause in sql server?

569


Is sql server implemented as a service or an application? : Sql server database administration

509






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

100


What is bcp? When does it used?

545


What is difference between group by and having?

559


When we should use and scope of @@identity?

538


What do you mean by sql server 2005 express management tools?

786


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

512


Explain concepts of analysis services?

506


When is the use of update_statistics command?

553


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

543


Explain user defined views?

573