SELECT * FROM sys.objects WHERE type='u' AND name LIKE 'Prefix%'

SELECT table_name FROM sys.tables WHERE table_name LIKE 'SomePrefix%'

Sometimes You are Confused to find table names with same names prefix.If there are many tables with name starts from Employee.1/ EmployeePart1 , 2/ EmployeePart2 , 3/ EmployeePart3 , 4/ EmployeePart4select * from sys.tables where name like '%Employee%'O/P:1/ EmployeePart1 2/ EmployeePart2 3/ EmployeePart3 4/ EmployeePart4