Get multiple tables name with same prefix and suffix keyword

Sandeepraturi
Posted by Sandeepraturi under ASP.NET category on | Points: 40 | Views : 1395
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'

Comments or Responses

Login to post response