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

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2207


What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

594


What is the use of nvl work?

561


Can we add an identity column to decimal datatype?

577


What the different components of Replication and what is their use?

554






if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

525


What is cursors?

636


Explain syntax for disabling triggers?

520


Explain sql server service broker?

510


Are semicolons required at the end of sql statements in sql server 2005?

565


What are the differences between decimal and float in ms sql server?

563


What is the rdl file?

88


Does group by or order by come first?

536


How do you improve the performance of a SQL Azure Database?

115


How to select an exiting database using mssql_select_db()?

509