Name the 2 types of classifications of constraints in SQL Server?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Name the 2 types of classifications of constraints in SQL Server?
Question Posted on 30 Sep 2022

Home >> DataBase >> sql questions >> Name the 2 types of classifications of constraints in SQL Server?

Name the 2 types of classifications of constraints in SQL Server?
Below are the 2 types of classifications of constraints in SQL Server:-

(1)Column Types Constraints:-When we say about Column Types Constraints it is applied to the columns of table in SQl Server. And definition of these can be given at the time of the creation of a table in the database.

(2)Table Types Constraints:-These type of constraints are applied on the table and these are defined after the creation of a table is complete. And we use Alter command to apply the table type constraint.

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)