Post reply

Find a string in DB objects.

  • October 1, 2007 at 10:02 am

    #118865

    Comments posted to this topic are about the item Find a string in DB objects.

  • May 21, 2008 at 4:26 pm

    #818909

    Important Note/Update:

    Since this was written, there are three types of functions now, so the IN statements should be updated to include the updated types desired to be searched.

    ala MSDN...> http://msdn.microsoft.com/en-us/library/aa260447(SQL.80).aspx

    xtype char(2) Object 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

    Therefore

    IN ('C','D','FN','P','TR','V')

    to

    IN ('C','D','FN','IF','TF','P','TR','V')

    at a minimum.

    😉

Viewing 2 posts - 1 through 1 (of 1 total)

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