what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83748 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sivanagireddy.k
constraints nothing but condition on column in the table by using constraint checking process or validation pprocess has been done.
constraints are 6 tyes
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key
types of level in constraints
column level
table level
send ur queries to this mail id rsivanagireddy@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is 5nf in normalization form?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Explain iaas, paas and saas?
How are the unique and primary key constraints different?
Explain ms sql server reporting services vs crystal reports?
What is a fill factor?
What are the tables in sql?
Which is faster statement or preparedstatement?
Explain what is dbcc?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is blocking?
Explain about analysis services?
What is auditing in sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Do you know the isolation level that sql server support?
