Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90844 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ramesh.n
constraints are the restrictions or limitations that are
being imposed on the columns of a table to validate the data
either for insertion or updation constraints can be imposed
either during the process of table creation of a level.
There are 8 types of constraints
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key
7.composite primary key
8.composite unique key
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Tell me when is the update_statistics command used?
What is a field in a table?
What is xml datatype?
How do you improve the performance of a SQL Azure Database?
How do I open a .db file?
How do use Having,Group by,Group function in SQL?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is 'write-ahead log' in sql server 2000 ?
When would you prefer to have a minimum number of indexes?
What is the index requirement in SQL Azure?
What is the tcp/ip port on which sql server runs?
How many types of triggers in sql server?
What does set rowcount do?
How to turn off warning messages during php execution?
What are the different types of stored procedures?
