What are constraints? Explain different types of
constraints?
Answer Posted / rev
3 basic types
1.entity constraint:
check
not null
null
2.domain constraint:
unique
primary
composite primary key
3.referential constraint:
integrity
foreign
Is This Answer Correct ? | 27 Yes | 28 No |
Post New Answer View All Answers
How many full-text indexes can a table have?
Which command is used for user defined error messages?
How to select some specific columns from a table in a query in ms sql server?
What is the default server name for sql server?
What are the database roles? : sql server security
Does group by or order by come first?
Why it is recommended to avoid referencing a floating point column in the where clause?
Explain differentiate between a having clause and a where clause?
How many types of schemas are there?
What is 'Join' and explain its various types.
What is data file in computer?
How to disconnect from a sql server using mssql_close()?
How can you fetch alternate records from a table?
Does view occupy space?
Do you know what guidelines should be followed to help minimize deadlocks?