What are constraints? Explain different types of
constraints?

Answer Posted / taru mathur

a constraint refers to a condition or a check that is
applied to a coloumn(field)or a set of coloumns in a table.
Their are mainly five types of constarints:
1. UNIQUE CONSTRAINT
2. PRIMARY KEY CONSTRAINT
3. DEFAULT CONSTRAINT
4. CHECK CONSTRAINT
5. FOREIGN KEY CONSTRAINT

Is This Answer Correct ?    5 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of toad or sqldbx.?

728


Explain about link server in sql server?

535


What are the types of indexes?

600


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

554


Which table keeps information about stored procedures?

539






What is named calculation? : sql server analysis services, ssas

536


Can foreign key be duplicate?

633


What are out-of-range errors with date and time literals?

556


How many triggers you can have on a table?

535


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

540


Describe in brief sql server monitoring ways.

591


How to disable a login name in ms sql server?

595


Which tcp/ip port does the sql server run on? How can it be changed?

531


How to execute the cursor queries with "open" statements?

618


How do I run a trace in sql server?

507