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
What is the use of toad or sqldbx.?
Explain about link server in sql server?
What are the types of indexes?
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
Which table keeps information about stored procedures?
What is named calculation? : sql server analysis services, ssas
Can foreign key be duplicate?
What are out-of-range errors with date and time literals?
How many triggers you can have on a table?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Describe in brief sql server monitoring ways.
How to disable a login name in ms sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
How to execute the cursor queries with "open" statements?
How do I run a trace in sql server?