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

Answer Posted / krishna

constraints are use to maintain the relation between the two tables. sql contains the 5 types of constraints
1.primary key
2.foreign key
3.unique key
4.Not null
5.check

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the ways in which dynamic sql can be executed?

794


How is SQL Azure different than SQL server?

116


What is the downside of using udf?

758


Define tool Manage Statistics in SQL Server 2000 query ?

741


How do I view a script in sql server?

732


Ms sql server index?

745


What is change tracking in sql server?

714


What are advantages of ssrs or why we should use ssrs?

117


What is it unwise to create wide clustered index keys?

752


Does a full backup include transaction log?

689


Explain indexing and what are the advantages of it?

724


What new data source types were added in ssrs 2014?

130


What is co-related sub query?

736


List the different types of joins?

755


Where can you find the error log information? : sql server database administration

747