What are constraints? Explain different types of
constraints?
Answer Posted / wishpreet kaur
constraints are the restictions or boundaries.
we can categorise the constraints into 3 categories:
1. object constraints: specify that some objects depends
entirely or partially on other objects.
2. dynamic constraints: specify relationship among states
and events.
3. functional constraints: specify relationship among
operations.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are different replication agents and what's their purpose? : sql server replication
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are different types of join?
How you can get a list of all the table constraints in a database?
What are the database objects? : SQL Server Architecture
How to execute a sql statement using odbc_exec()?
What are the benefits of normalization?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How to connect to SQL Azure Database by using sqlcmd?
What is a unique key constraint?
What is the difference between having clause and where clause in sql server?
Explain iaas, paas and saas?
How to test a dml trigger in ms sql server?
What is for xml in sql server?
What stored by the model?