what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 84419 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / yashwanth
constraints are the rules enforced on data columns on a
table
use:constraints are used to limit the type of data that
can go in to a table
there are some constraints
a primarykey constraint
a unquekey constraint
a foreinkey constraint
a check constraint
a not null constraint
a default constraint
| Is This Answer Correct ? | 47 Yes | 13 No |
Post New Answer View All Answers
How to find table changes in sql server?
What are different type of Collation Sensitivity?
Distinguish between commit and rollback?
What is the difference between seek predicate and predicate?
What happens to a trigger with multiple affected rows?
Why should we go for stored procedures? Why not direct queries?
Explain the usage of floor function in sql server.
Explain the phases a transaction has to undergo?
Explain the dbcc pintable command when would you use it?
How to convert a table data in XML format in sql server?
How to get the definition of a trigger back?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the difference between stored procedure and user defined functions?
Does sql server 2000 clustering support load balancing?
Can one drop a column from a table?
