what is Constraint? How many types of constraints in SQL ?
Answer Posted / shelly
Constraints are used to limit the type of data that goes
into a table.Constraints can be declared at the time of
creating a table or by altering the already created table.
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References
6)Default
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to integrate the ssrs reports in application?
What is the difference between implicit and explicit transaction?
How to handle error or exception in sql?
what is normalization? Explain different levels of normalization? : Sql server database administration
What are the new features of sql server 2012 reporting service?
Do you know what is fill factor and pad index?
Can you explain the disadvantages/limitation of the cursor?
What is a rownum?
Explain what is log shipping?
How to concatenate two strings in SQL Server.
Explain hostprotectionattribute in sql server 2005?
What is the difference between a clustered index and a non-clustered index?
What is user-defined multi-statement table-valued function?
Explain sub-query?
Explain features and concepts of analysis services?