1
Reply

Find Tables From DataBase With Same Prefix Name?

Satyaprakash Samantaray

Satyaprakash Samantaray

Apr 04, 2017
359
1

    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