SQL: Find a table name across all databases

SELECT name FROM sys.databases WHERE OBJECT_ID(QUOTENAME(name) + '.[dbo].[TableName]', 'U') IS NOT NULL

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.