Interviews - C# Corner

Satyaprakash Samantaray
Find Tables From DataBase With Same Prefix Name?
By Satyaprakash Samantaray in SQL Server onApr 04 2017
  • Goyal
    Sep, 2018 5

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

    • 1
  • Utsavi Bhatt
    May, 2018 16

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

    • 1
  • 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

    • 1

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS