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
WHERE name LIKE '%_Test'