Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88283 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
What is difference between inner join and full join?
Can you explain what are commit and rollback in sql?
What options are available to audit login activity? : sql server security
Which joins are sql server default?
What is create statement?
What are “phantom rows”?
How do you know if sql server is running on your local system?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is clustered primary key?
Differentiate sql server reporting services vs. Crystal reports?
What are views in ms sql server?
How to use order by with union operators in ms sql server?
What is spatial and temporal data?
How to define output parameters in stored procedures?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
