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
How to change the data type of an existing column with "alter table" statements in ms sql server?
What are the advantages to use stored procedures?
What happens if we shrink log file in sql server?
How do I setup a local sql server database?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Explain triggers in sql?
What is your recommendation for a query running very slow? : sql server database administration
Detail about the hardware which is supported by SQL server?
What does <> symbol mean?
How to provide values to user defined function parameters?
How to download and install microsoft sql server management studio express?
What is a subquery in a select query statement in ms sql server?
explain databases and sql server databases architecture? : Sql server database administration
Explain the difference between cross join and full outer join?
Difference between DELETE and TRUNCATE?