Find all tables whose name ends with a certain suffix
information-schema, select, sql, sql-server, sql-server-2008
Solution
Try this:
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.tables
WHERE TABLE_NAME LIKE '%_History'
OR
SELECT name
FROM sys.tables
WHERE name LIKE '%_History'
Problem
I have thousand of tables in database. Some names end with `_History`. For example : ``` abc_History bcd_History 123_History ``` How do I find all tables which name is end with `_History`. Some thing like: ``` SELECT table_name FROM sys.tables WHERE table_name LIKE '_History%' ``` And ``` error : Invalid column name 'table_name'. ```