what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83648 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
Define candidate key, alternate key, and composite key.
What are commonly used odbc functions in php?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to create a simple user defined function in ms sql server?
How to connect a database with sql express.?
What are the steps to follow to configure SQL*Net?
Explain use of expression builder.
What is db stored procedure?
Explain try...catch with sql server?
What are the mathematical functions supported by sql server 2005?
Explain nested join?
Name three of the features managed by the surface area configuration tool? : sql server security
What is stored procedures?
List some case manipulation functions in sql?
