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 can I tell if sql server is 32 or 64 bit?
How to test odbc dsn connection settings?
What are the restrictions that views have to follow? : SQL Server Architecture
Can we call future method from trigger?
Write SQL queries on Self Join and Inner Join.
Explain some stored procedure creating best practices or guidelines?
What are the different types of data sources in ssrs?
Differentiate between mongodb vs. Sql server?
Is foreign key a primary key?
Does index speed up select statements?
What is change tracking in sql server?
How do you trace the traffic hitting a sql server?
Write query to return all rows sql?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is difference between group by and having?