Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 139588 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
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 are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the purpose of the tempdb database?
What is difference between standardization and normalization?
Can we join two tables without primary key?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Explain Normalization and DE normalization
What happens if the update subquery returns multiple rows in ms sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Explain the steps needed to create a scheduled job?
Give the query of getting last two records from the table in SQL SERVER?
Explain the use of keyword with encryption. Create a store procedure with encryption?
What is SQL Azure?
What are the export options of ssrs?
What is unpivot?
What is the difference between function and stored procedure in sql server?
