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


Please Help Members By Posting Answers For Below Questions

What is an inner join?

530


When does a workload on SQL Azure get throttled?

113


What are the different authentication modes in sql server?

577


If a table does not have a unique index, can a cursor be opened on it?

517


How do I get to sql server configuration manager?

520






What objects does the fn_my_permissions function reports on? : sql server security

563


What is difference between cte and view?

526


What is 'write-ahead log' in sql server 2000 ?

627


How can we get count of the number of records in a table?

547


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?

652


What are the new features of sql server 2008 r2 reporting service?

110


Explain isolation levels that sql server supports?

569


Define Unique Key?

594


How to read data in a table with "select" statements?

563


You want to implement the many-to-many relationship while designing tables. How would you do it?

566