Monday, May 14, 2012

XType values in Sys.sysobjects

**select *from sys.sysobjects where xtype=? **

Question mark replace by below values.

    C = CHECK constraint
    D = Default or DEFAULT constraint
    F = FOREIGN KEY constraint
    L = Log
    P = Stored procedure
    PK = PRIMARY KEY constraint (type is K)
    RF = Replication filter stored procedure
    S = System table
    TR = Trigger
    U = User table
    UQ = UNIQUE constraint (type is K)
    V = View
    X = Extended stored procedure

No comments:

Post a Comment

Dear User,

Thank you very much for your kind response