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.