How to use Oracle linked server shows all tables

By FoxLearn 5/15/2024 9:04:50 AM   233
How to use Oracle linked server shows all tables from all schemas in SQL Server Management Studio

Open your sql management studio, then you can use the sql query below.

SELECT *
FROM OPENQUERY(ORCL_LINK, 'SELECT table_name, owner FROM all_tables ORDER BY owner, table_name')

As a result you will see all schemas and all tables