What are constraints? Explain different types of
constraints?

Answer Posted / hari

Constraint : To Restrict the voilation of irrelegular data
and maintain data integrity.

Primary key
Unique Key
NotNull
Forigen Key
Check

Is This Answer Correct ?    73 Yes 45 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of dml?

548


How do I find query history in sql server?

510


You want to implement the many-to-many relationship while designing tables. How would you do it?

553


What is explicit cursors?

550


Define Business Edition in SQL Azure?

88






What is the difference between char, varchar and nvarchar?

564


What is a natural primary key?

519


Explain the difference between cross join and full outer join?

494


What are the limitations in ssrs on sql server express edition?

137


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

87


What do you understand by coalesce in sql server?

493


what is normalization? : Sql server database administration

522


How to use user defined functions in expressions?

544


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1298


What is the difference between ‘having’ clause and a ‘where’ clause?

543