what is Constraint? How many types of constraints in SQL ?
Answer Posted / ramesh.n
constraints are the restrictions or limitations that are
being imposed on the columns of a table to validate the data
either for insertion or updation constraints can be imposed
either during the process of table creation of a level.
There are 8 types of constraints
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key
7.composite primary key
8.composite unique key
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How can we solve concurrency problems?
What is difference between sql and sql server?
Describe in brief authentication modes in sql server.
role of sql sever 2005 in database rather than any other database
What is auditing in sql server?
What is ms sql server index?
What is db stored procedure?
What does man by sql wildcard characters in sql server?
What is the security principal at the database level that represents your session?
How to choose all records from the table?
What command would you use to create an index?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is change data capture (cdc) in sql server 2008?
Explain the types of indexes.
What are points to remember while using the fillfactor argument?