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
Can we update data in a view?
What are cursors stored procedures and triggers?
Tell me extended events in sql server 2008?
What is difference between rollback immediate and with no_wait during alter database?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How do I view a stored procedure in sql server?
What is the default server name for sql server?
Where the sql logs gets stored? : sql server database administration
What is your recommendation for a query running very slow? : sql server database administration
What is master database? : SQL Server Architecture
How many null values we can have in a unique key field in sql server?
What is de-normalization and what are some of the examples of it?
What methods do you follow to protect from sql injection attack?
What do you know about normalization and de- normalization?
Write the queries for commands like Create Table, Delete table, Drop Table etc.