what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83723 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vinod
Constraints are used to restrict the insertion of unwanted data.
Using constraints you can maintain data integrity by preventing invalid data being entered.
Constraints are Five type
Primary key
Unique Key
Foreign Key
Not Null
Check
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why and when do stored procedure recompile?
What is Dependency Injection and provide example?
Is BCNF better than 2NF & 3NF? Why?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is the difference between DATETIME2 and DATETIME?
What area unit the various kinds of info compression introduced in sql server 2008?
How can sql server instances be hidden? : sql server security
Explain about builtinadministrator?
What is the difference between count and distinct count?
What is normalization 1nf 2nf 3nf?
What is the difference between join and inner join?
Explain the third normal form(3nf)?
What does COMMIT command do?
How to convert numeric values to integers in ms sql server?
What is user defined stored procedures?
