4
Reply

Find Tables From DataBase With Same Prefix Name?

Satyaprakash Samantaray

Satyaprakash Samantaray
8y
7.9k
2
Reply
    Code Alone
    SELECT * FROM sys.objects WHERE type='u' AND name LIKE 'Prefix%'
    Code Alone
    7y
    1
    Utsavi Bhatt
    SELECT table_name FROM sys.tables WHERE table_name LIKE 'SomePrefix%'
    Utsavi Bhatt
    7y
    1
    Satyaprakash Samantaray
    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
    Satyaprakash Samantaray
    8y
    1
    Rajeev Kumar

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

    Rajeev Kumar
    2y
    0
Message