Finding tables containing JID, UserJID, or CharID (For cleanup purposes)

[Witchy Moo]

Hello, here I'll share simple query to find tables containing "JID", "UserJID", or "CharID", for cleanup purposes. Well actually, it'll be easier to cleanup the whole thing if you wanna start fresh, and this prolly old and useless to you, but I'll share it anyway.

Now the boring part:

USE [SRO_VT_SHARD]
GO
-- Find tables containing field "JID" or "UserJID" or "CharID"
SELECT c.name AS ColName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE 'JID' OR c.name LIKE 'UserJID' OR c.name LIKE 'CharID' ORDER BY c.name, TableName ASC

Note: that's only for SRO_VT_SHARD. do the same in ACCOUNT and LOG database.

Result:

[MentaL]

[blapanda]

Oh, sure it might be "old", as other (aka jerks) may or going to comment here, but haven't had the idea doing the same as data related.
Having a similar script for Database related stuff.

Thanks, might become handy scripting more procedure related items. :)