DECLARE @table sysname, @SQL NVARCHAR(MAX)
SET @table = ‘Table_Name’ —– Replace Table_Name by your table name you want to find it
SET @SQL = ”
SELECT @SQL = @SQL + ‘;
IF EXISTS (SELECT 1 from ‘ + QUOTENAME(name) + ‘.INFORMATION_SCHEMA.Tables WHERE Table_Name = @table
AND TABLE_TYPE = ”BASE TABLE”)
PRINT ”Table ‘ + @table + ‘ found in ‘ + name + ””
FROM sys.databases
EXECUTE sp_executeSQL @SQL, N’@table sysname’, @table
Like this:
Like Loading...
Related
Published by Mustafa EL-Masry
MY NAME IS MUSTAFA ELMASRY
I have total years’ Experience +10 in SQL Server technology started my carrier path in 2008 as technical Support and now I am working as a Database Consultant in the banking sector managing around 200 DB Servers AS Production servers plus other environments UAT, SIT and staging servers, I have High-level experience in Database Administration, Performance Tuning, disaster recovery, development (T-SQL), SSRS. And Good Experiences in SSIS, SSAS AZURE DB, Automation (Power-Shell + TSQL)
I will be Happy if you take a look on my main profile to know more information about me and to know how you can contact me (https://mostafaelmasry.com/about-me/)
View all posts by Mustafa EL-Masry
