What are constraints? Explain different types of
constraints?
Answer Posted / kannan g
Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null
| Is This Answer Correct ? | 10 Yes | 10 No |
Post New Answer View All Answers
How to perform backup for certificates in sql server? : sql server security
What objects does the fn_my_permissions function reports on? : sql server security
Write a program using SQL queries to find a unique entry in a table.
Explain the third normal form(3nf)?
Tell me what are the essential components of sql server service broker?
What are the differences between union, intersect, and minus operators?
Explain how you can configure a running aggregate in SSRS?
Explain the different types of joins?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is explicit mode in sql server?
What is difference between Datepart() and Datename() in SqlServer?
What are the security related catalog views? : sql server security
What is data compression? : sql server database administration
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
How do I find the query plan in sql server?