This portal is to share my acquired knowledge related to Sql Server. I hope will be helpful for novice and professionals.

Monday, November 22, 2010

Difference between XType and Type Column in sysobjects view Sql Server 2005?

Both are same , used to identity the type of objects.

Object type. Can be one of the following object types:

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

L = Log

FN = Scalar function

IF = In-lined table-function

P = Stored procedure

PK = PRIMARY KEY constraint (type is K)

RF = Replication filter stored procedure

S = System table

TF = Table function

TR = Trigger

U = User table

UQ = UNIQUE constraint (type is K)

V = View

X = Extended stored procedure



Type column is for backward compatibility.


Randhir

1 comment:

Gobinda Sharma said...

Really helpful.....Thanks