SYSOBJECTS xtypes & dropping a xtype

Posted on 2006-05-12
Last Modified: 2009-03-24
1) We are using SQL Server 2000 on windows 2000 server.
2) What do following xtype's in SYSOBJECTS system table point to:
U, F, TF & S.
3) How do I drop a xtype for ex: default since it is attached to the column of a table.
Question by:k_murli_krishna
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    U : user table
    F : function
    TF: table-function
    S : system table
    LVL 75

    Accepted Solution

    UObject type. Can be one of these object types:
    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
    LVL 11

    Assisted Solution

    by:Ved Prakash Agrawal
      DROP CONSTRAINT DefaultConstraintName

    you can use sysobjects table which can give you the name of the constraint...

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now