Find a string in DB objects.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by James Travis » Find a string in DB objects.

Find a string in DB objects.

Rate Topic

Display Mode

Topic Options

Author

Message

Antares686

Posted Monday, October 01, 2007 10:02 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

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

Post #405111

temp89108

Posted Wednesday, May 21, 2008 4:26 PM

Forum 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.

Wink

Post #504892

« Prev Topic | Next Topic »

Permissions