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


Please Help Members By Posting Answers For Below Questions

What are different replication agents and what's their purpose? : sql server replication

575


What is log shipping? Can we do logshipping with SQL Server 7.0 ?

579


What are different types of join?

762


How you can get a list of all the table constraints in a database?

518


What are the database objects? : SQL Server Architecture

555






How to execute a sql statement using odbc_exec()?

574


What are the benefits of normalization?

578


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?

99


How to connect to SQL Azure Database by using sqlcmd?

110


What is a unique key constraint?

534


What is the difference between having clause and where clause in sql server?

574


Explain iaas, paas and saas?

74


How to test a dml trigger in ms sql server?

581


What is for xml in sql server?

540


What stored by the model?

552