What are constraints? Explain different types of
constraints?
Answer Posted / taru mathur
a constraint refers to a condition or a check that is
applied to a coloumn(field)or a set of coloumns in a table.
Their are mainly five types of constarints:
1. UNIQUE CONSTRAINT
2. PRIMARY KEY CONSTRAINT
3. DEFAULT CONSTRAINT
4. CHECK CONSTRAINT
5. FOREIGN KEY CONSTRAINT
Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is the most common trace flags used with sql server?
how can you attach more than 20 ldf files in sql server
When do you think a developer should use sql server-based cursors?
can a table be moved to different filegroup? : Sql server administration
Difference between uniqe index and uniqe constraint?
What is replication with database mirroring? : sql server database administration
How will you find out if there are expensive SQL statements running or not?
What are some examples of schemas?
whats new about truncate in sql server 2008?
Explain various On-Delete options in a DB table. Which is the default option?
What is a partition key?
List all the types of user-defined functions?
What number sorts of privileges are accessible in sql?
What is a transact-sql statement batch in ms sql server?
What is a natural primary key?