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
Who is the owner of a schema in ms sql server?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Describe in brief databases and sql server databases architecture.
Difference between Logical Page and Physical Page in SSRS.
Where is localdb stored?
What is SQL Azure Federations?
What is temporal data type?
How many types of functions are there in sql server?
What is SubQuery in SQL Server 2008
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is the difference between deallocate cursor and close cursor?
Tell me what is the stuff and how does it differ from the replace function?
How is SQL Azure different than SQL server?
How do I view a trc file?
What are three major types of constraints?