What are constraints? Explain different types of
constraints?
Answer Posted / g.rajesh(m.tech)
constrain kis a rule.
types of constriants are
1.domain constrain:
eg:chjeck,default,not null.
2.entity constraints:
eg:primary key.
unique key
3.referential constrain:
eg:foreign key
Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
What is an inner join?
When does a workload on SQL Azure get throttled?
What are the different authentication modes in sql server?
If a table does not have a unique index, can a cursor be opened on it?
How do I get to sql server configuration manager?
What objects does the fn_my_permissions function reports on? : sql server security
What is difference between cte and view?
What is 'write-ahead log' in sql server 2000 ?
How can we get count of the number of records in a table?
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?
What are the new features of sql server 2008 r2 reporting service?
Explain isolation levels that sql server supports?
Define Unique Key?
How to read data in a table with "select" statements?
You want to implement the many-to-many relationship while designing tables. How would you do it?