what is Constraint? How many types of constraints in SQL ?
Answer Posted / sowndharya-bca gvg colleg
constraints are enforced on data being stored in a table
1-primary key constraint
2-foreign key constraint
3-unique key constraint
other constraints~~~~:
business rule constraints
column level constraints
table level constraints
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How to enter date and time literals in ms sql server?
Explain external key management in sql server 2008
What are 3 ways to get a count of the number of records in a table?
What is the dbcc command and why is it used?
What are the differences between having and where clause.
explain the storage models of olap? : Sql server database administration
Explain how to integrate the ssrs reports in application?
What is the process of normalising?
What are wait types?
How do I view a trc file?
List out the difference between union and union all in sql server?
How to invoke a trigger on demand?
Can you pass expressions to stored procedure parameters?
What is stored in the mssqlsystemresource database? : sql server database administration