what is Constraint? How many types of constraints in SQL ?
Answer Posted / raghunath k
Constraints are some rules that are inforced on the data object.
there are five types of costriants in SQL, they are
1. NOT NULL CONSTRAINTS.
2. UNIQUE CONSTRAINTS.
3. PRIMARY KEY CONSTRAINTS.
4. FOREIGN KEY CONSTRAINTS.
5. CHECK CONSTRAINTS.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the data tier application?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What action plan is preferred if sql server is not responding?
What stored by the tempdb ? : sql server database administration
What is the impact on other user sessions when creating indexes?
What command would you use to add a column to a table in sql server?
How to change server name in sql server?
Define clusters?
What is a covering index?
What is data source in connection string?
Explain temporary table vs table variable by using cursor alternative?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is the difference between a local and a global temporary table?
How do I setup a local sql server database?
What are different type of Collation Sensitivity?