Skip to content

Instantly share code, notes, and snippets.

@kieran23101

kieran23101/CheckForTable.sql

Created August 7, 2019 12:28
Show Gist options
  • Save kieran23101/c406014c4b51f007772587a66ac525e0 to your computer and use it in GitHub Desktop.
Save kieran23101/c406014c4b51f007772587a66ac525e0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CheckForTable.sql
EXEC sp_MSforeachdb
'IF EXISTS (SELECT * FROM [?].INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = ''PaleDNN_Templates'')
BEGIN
PRINT DB_NAME(DB_ID(''?''))
END'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment