Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 89668 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mudit
Constraint are the rules enforced on data columns on table.
Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check
| Is This Answer Correct ? | 338 Yes | 56 No |
Post New Answer View All Answers
What are transactions in sql?
What do you do in data exploration
What is the security model used in sql server 2005?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How to receive output values from stored procedures?
How can we remove orphan records from a table?
What are SSL and TSL protocols?
How many databases Microsoft SQL server provides?
Which table keeps information about stored procedures?
What is the difference between executequery () and executeupdate ()?
What happens if ntwdblib.dll is missing on your machine?
List out a number of the wants to setup a SQL Server failover cluster?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
How do we know if any query is retrieving a large amount of data or very little data?
Mention the differences between having and where clause.
