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
explain different levels of normalization? : Sql server database administration
What are the differences between left join and inner join in sql server?
what are constraints? Explain different types of constraints? : Sql server database administration
What is the difference between set and select?
Why use cursor in sql server?
What are the results of running this script?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
what are the core components of SSRS?
What do you understand by sql server agent?
Why do we backup Active Directory ?
How to configure and test odbc dsn settings?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What are the general features of sql server management studio? : sql server management studio
What causes index fragmentation?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?