Post reply

sys Table Name?

  • January 2, 2008 at 5:16 am

    #180103

    In sysobjects table there is a column "type". In this information like P,F, FN, PK, U, UQ etc..... I want to know Description about these information.

    In which table these description are available?

    Kishore KK

  • January 2, 2008 at 5:20 am

    #763988

    it denotes Object type. Can be one of these values:

    C = CHECK constraint

    D = Default or DEFAULT constraint

    F = FOREIGN KEY constraint

    FN = Scalar function

    IF = Inlined table-function

    K = PRIMARY KEY or UNIQUE constraint

    L = Log

    P = Stored procedure

    R = Rule

    RF = Replication filter stored procedure

    S = System table

    TF = Table function

    TR = Trigger

    U = User table

    V = View

    X = Extended stored procedure

  • January 2, 2008 at 5:21 am

    #763989

    I don't think the descriptions are actually stored in a table. But from BOL here's the overview:

    C = CHECK constraint

    D = Default or DEFAULT constraint

    F = FOREIGN KEY constraint

    L = Log

    FN = Scalar function

    IF = Inlined 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

    [font="Verdana"]Markus Bohse[/font]

  • January 2, 2008 at 5:24 am

    #763990

    Thanks

    what is mean by UQ?

  • January 2, 2008 at 5:28 am

    #763993

    UQ = UNIQUE constraint

    for complete reference

    http://msdn2.microsoft.com/en-us/library/ms190324.aspx

  • January 2, 2008 at 5:29 am

    #763994

    UQ means Unique constraint. these make sure that there are no duplicate values in the specified columns.

    Check out BOL for more info.

    "Keep Trying"

  • January 2, 2008 at 6:00 am

    #763998

    Use the sys.object view, rather than sysobjects. sys.objects has both a type and a type_description column, so you can see exactly what's what.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply