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

How to create indexed view?

587


What is a document index?

590


What is the difference between deallocate cursor and close cursor?

726


What is a transactions?

606


How to list all objects in a given schema?

564






Determine how to use the inserted and deleted pseudo tables?

542


What is trigger in salesforce?

502


What are sql azure firewall rules?

85


Explain aggregate functions?

567


How to create percentile function?

108


What are data resources?

508


What is the difference between online clustering and Offline clustering?

1922


What is the difference between a function and a trigger?

577


What is tempdb database? : SQL Server Architecture

608


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

574