what is Constraint? How many types of constraints in SQL ?
Answer Posted / lekhraj
Constraints are the way by Databse managing the data inegrity.
Types of constraint are:-
1)NOT Null
2)Default
3)Check
4)Rule
5)Primary
6)Unique
7)Foreign
| Is This Answer Correct ? | 46 Yes | 65 No |
Post New Answer View All Answers
How will you find out if there are expensive SQL statements running or not?
What extended events?
What are the advantages of the mirroring?
when you create a database how is it stored? : Sql server database administration
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to create a trigger for insert only?
Why do we use trigger?
What is the main purpose of having conversation group?
What is history table in sql server?
What is the importance of three tier architecture?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
how to overcome kernel isssues
Explain what is the use of custom fields in report?
How to create an inline table-valued function?
Do you know the isolation level that sql server support?