Get same prefix- suffix tables from SQL Server

In this tutorial we will understand, How we can get same prefix- suffix tables from SQL Database?

Follow these steps-

Step-1: Create 3 to 4 table with same name suffix keywords like :

table1_Test, table2_Test, table3_Test

Step-2: Write below mentioned query

SELECT name
FROM sys.tables
WHERE name LIKE '%_Test'

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.