Satyaprakash Samantaray
Find Tables From DataBase With Same Prefix Name?
By Satyaprakash Samantaray in SQL Server on Apr 04 2017
  • Satyaprakash Samantaray
    Apr, 2017 4

    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

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS