how to know name of a table in sql code example
Example 1: sql server find table name
select * from sys.tables where name like '%tablename%'
Example 2: how to check table name in current database sql
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=db_name()
and TABLE_NAME like'%table_name%'--to check particular table