what is Constraint? How many types of constraints in SQL ?
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
How do you trace the traffic hitting a sql server?
How do you size a resultset?
How do clustered indexes store data?
Do you know what is replace and stuff function in sql server?
What is difference between delete and truncate commands?
How to name query output columns in ms sql server?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Describe the left outer join & right outer join. : sql server database administration
what are the core components of SSRS?
What are the main differences between #temp tables and @table variables and which one is preferred?
How to define the name and server for a new dsn?
Where do you find the default Index fill factor and how to change it?
Benefits of Stored Procedures?
What were the latest updates to SQL Azure service?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?