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

Answer Posted / agasaud

Constraints are Boundaries or Rules To Set on a Table.

Types of Constraints are :

Primary Key
Uniwue Key
Check Constraints
Default Constraints
Not Null
References

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a hint?

752


How to get the number of affected rows?

745


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2048


What are the steps to take to improve performance of a poor performing query? : sql server database administration

803


What is data source in connection string?

654


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1978


Explain the truncate command? : SQL Server Architecture

795


What is the synonym of join?

705


What is Replication?

823


Define magic tables in sql server?

769


What are ddl triggers and types of ddl trigger?

802


Give a example to search fr a string in all stored procedure in sql server.

712


Do you know how to make remote connection in database?

727


What is dbcc? Give few examples.

761


How do I delete a sql server database?

742