what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 79895 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ns
constraints are like an a right or any event which can we
apply on our table or column, or its an rule of integrity
there is an types of constraint:-
1.primary key
2.foreign key
3.unique
4.check
5.default
6.not null
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is tempdb in sql server?
What is difference between count (*) and count 1?
What command is used to create a database in the sql server and how?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is snapshot report?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Explain cursor as data base object?
What is the difference between drop table and truncate table?
What is a trigger what are the advantages of trigger?
Explain sql delete command?
where the connection string store in the database
Why are sql functions used?
Explain the categories of stored procedure?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is a transact-sql statement batch in ms sql server?
