Find a string in DB objects.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 1, 2007 at 10:02 am

  #118865

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

• temp89108

  Grasshopper

  Points: 17

  More actions

  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.