what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 80064 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / scornguy
Constraints are used to limit the type of data that can go
into a table.
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
| Is This Answer Correct ? | 225 Yes | 29 No |
Post New Answer View All Answers
What are unicode character string data types in ms sql server?
What is nested transaction?
What is difference between equi join and inner join?
What is xdr?
What are the differences between DDL, DML and DCL in SQL?
How to create a local temporary stored procedure?
Explain can SSRS reports Cache results?
What is the benefit of normalization?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
what data regions are and what are the different data regions?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is collation sensitivity?
What is read committed?
Explain index in sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
