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 mscorsvw.exe - process - microsoft .net framework ngen?
what are acid properties? : Sql server database administration
How to insert data with null values?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How real and float literal values are rounded?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is the use of for clause?
What is filtered index?
What is a unique key constraint?
How can sql server instances be hidden? : sql server security
What is a database in ms sql server?
What is a unique index?
Do you know what is difference between index seek vs. Index scan?
what is the difference between count(*) and count(1) ?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration