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
Which tools are available to manage SQL Azure databases and servers?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is de-normalization in sql database administration? Give examples?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is nolock hint in sql server 2008
What is a document index?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to add more data to the testing table in ms sql server?
How do I find sql server instance name?
What is built-in/administrator?
How ssrs maintain security?
Does group by or order by come first?
Benefits of Stored Procedures?