Home » SQL Server » Get same prefix- suffix tables from SQL Server

Get same prefix- suffix tables from SQL Server

SQL Database Backup




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.



Leave a Reply