Find same name Suffix tables in SQL

 Create 2 to 3 table with same name suffix keywords like as below :

table1_Test, table2_Test, table3_Test



Query as below:

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

In above query _test is common suffix in all tables & Like keyword will help us to find common spell in all tables.

Output as below: