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
What is the Difference Between Primary and Foreign Key?
What is the difference between clustered and a non-clustered index?
How to get nth highest salary from employee table.
Explain transaction server consistency?
What is dbcc?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Explain steps of normalization?
Difference between DELETE and TRUNCATE?
What’s the use of custom fields in report?
What is a system database and what is a user database?
What are the main differences between #temp tables and @table variables and which one is preferred?
Name 3 ways to get an accurate count of the number of records in a table?
How to change server name in sql server?
What is the use of @@spid?
Do you know what is a linked server in sql server?