Get multiple tables name with same prefix and suffix keyword

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

FROM sys.tables
WHERE name LIKE '%_Test'

Comments or Responses

Login to post response