Find Tables From DataBase With Same Prefix Name?

SELECT name from sys.tables where name like ‘YourPrifix%’

Rajeev Kumar3y

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

Code Alone8y

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

Utsavi Bhatt8y

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/ EmployeePart4 select * from sys.tables where name like '%Employee%' O/P: 1/ EmployeePart1 2/ EmployeePart2 3/ EmployeePart3 4/ EmployeePart4

Satyaprakash Samantaray9y

Find Tables From DataBase With Same Prefix Name?

4 Answers