what is Constraint? How many types of constraints in SQL ?
Answer Posted / krishna
constraints are use to maintain the relation between the two tables. sql contains the 5 types of constraints
1.primary key
2.foreign key
3.unique key
4.Not null
5.check
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is catalog views?
What is the difference between Triggers and Stored Procedure?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is difference between index seek vs. Index scan?
What are trace flags and mention a few common trace flags used with sql server?
Explain hostprotectionattribute in sql server 2005?
How many triggers you can have on a table?
What do you mean by the term 'normalization'?
when you create a database how is it stored? : Sql server database administration
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What are the 7 disadvantages to a manual system?
What is the bookmark lookup and rid lookup?
Tell me what are the essential components of sql server service broker?
Explain the truncate command? : SQL Server Architecture