October 1, 2007 at 10:02 am
Comments posted to this topic are about the item Find a string in DB objects.
May 21, 2008 at 4:26 pm
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