Suppose you have multiple tables with same suffix or prefix keyword then how you will find out those tables name in one SQL query??
Steps are : 1 : Create 3 to 4 table with same name suffix keywords like :
table1_Test, table2_Test, table3_Test
2 : Write below mentioned query
SELECT name
FROM sys.tables
WHERE name LIKE '%_Test'