Home Forums SQL Server 2012 SQL 2012 - General How can I find where the table is ? Which database ? RE: How can I find where the table is ? Which database ?

  • July 26, 2016 at 12:42 pm

    #1892130

    EXEC sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name like ''%HENCDP%'''

    This works fine