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
Explain the etl (extraction, transformation, and loading)?
What are the reporting services components?
How can you manage sql azure security?
What is the difference between having clause and where clause in sql server?
Is sql server implemented as a service or an application? : Sql server database administration
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is bcp? When does it used?
What is difference between group by and having?
When we should use and scope of @@identity?
What do you mean by sql server 2005 express management tools?
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?
Explain concepts of analysis services?
When is the use of update_statistics command?
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?
Explain user defined views?