Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find a string in DB objects. Expand / Collapse
Author
Message
Posted Monday, October 01, 2007 10:02 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Thursday, April 17, 2014 3:54 PM
Points: 8,369, Visits: 733
Comments posted to this topic are about the item Find a string in DB objects.


Post #405111
Posted Wednesday, May 21, 2008 4:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2008 4:24 PM
Points: 1, Visits: 0
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.

Post #504892
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse