what is Constraint? How many types of constraints in SQL ?

Answer Posted / sivanagireddy.k

constraints nothing but condition on column in the table by using constraint checking process or validation pprocess has been done.

constraints are 6 tyes
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key

types of level in constraints

column level
table level

send ur queries to this mail id rsivanagireddy@gmail.com

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the properties of sub-query?

585


What does it mean if @@cursor_row returns a negative number?

575


What is Transparent Data Encryption?

591


How to list all tables in the database using odbc_tables()?

570


Can you explain full-text query in sql server?

554






How to connect php with different port numbers?

555


What is the server name in sql server?

560


Can a cursor be updated? If yes, how you can protect which columns are updated?

523


What are the types of resultset?

537


What is data source document?

551


How connect excel to sql server?

514


What is a hint?

582


What are the types of lock supported by ?

614


What is a mixed extent?

595


What is enhanced database mirroring in sql server 2008?

519