How do I find a table in SQL Server 2016?

advertisements

How can I find a table in SQL Server 2016?

I could use this to find the table in the current database:

SELECT *
FROM sys.Tables
WHERE name LIKE '%App_Current_Seq_Num%'

The problem is, I have several databases on the server.


Please try with the below sql query.

select * from [YourDatabaseName].INFORMATION_SCHEMA.TABLES where TABLE_NAME LIKE '%App_Current_Seq_Num%'