what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 83845 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / nivetha sri
Constraint are the certain condition which is used to
limit the data in the table.It can used before creating the
table and after creating the table.
TYPES OF CONSTRAINTS
1] Primary key
2]Foreign key
3]Unique key
4]Check
5]Not Null
6]Default
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
List the various tools available for performance tuning?
What the class forname () does?
Working with TLogs
Mention the differences between sql server and mysql.
What are pages and extents? : SQL Server Architecture
What is rtm version in sql server?
How to create a view with data from multiple tables?
How can I create a report based on a query? : sql server management studio
How to insert stored procedure result into temporary table?
How do I start and stop sql server?
What is format parameter in ssrs?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is attribute hierarchy? : sql server analysis services, ssas
How to create new tables with "create table" statements in ms sql server?
