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 difference between drop table and truncate table?
How to filter records of table in SQL SERVER?
Working with TLogs
What are the differences between stored procedure and the dynamic sql?
Can multiple columns be used in sql group by clause in ms sql server?
Which trace flags are enabled in sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
How to convert numeric expression data types by assignment operations?
Can we store videos inside the sql server table?
What do you mean by subquery?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
In which format does an image save in SQL Server database ?
How to set database to be read_only in ms sql server?
how can you check the level of fragmentation on a table? : Sql server administration
Can two tables have the same primary key?