what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83741 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rehan khan
constraint enforces rules at the table level and prevent the deletion of a table if there are dependencies .
constraint type:
primary key
foreign key
unique
not null
null
check
constraints can be defined at the time of table creation or after table has been created.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Tell me what is fill factor?
What are null values in ms sql server?
What is SQL Server?
How to manipulate data from one table to another table ?
When I delete any data from a table, does the sql server reduce the size of that table?
How to recover from sql injection? : sql server security
Explain the use of containers in ssis?
Is there any difference between primary key and unique with the not null condition?
last function used in MS Access to convert sql what function will use in sql
Where cross join is used?
Explain Reporting Life Cycle?
What is log cache in sql server?
Differentiate between ms sql server reporting services vs crystal reports?
What is the difference between count and distinct count?
