How to use Oracle linked server shows all tables
By FoxLearn 5/15/2024 9:04:50 AM 65
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
- How to select rows with same Id but different value in SQL Server
- SQL Server Migration Assistant
- How to Download and Restore Northwind database to SQL Server
- How to use SQL INSERT INTO SELECT Statement
- Data type SQL Server
- How to drop table if exists in sql server
- How to fix 'The specified directory for the INSTALLSHAREDDIR parameter is not valid'
- How to get all table names of a particular database using TSQL
Categories
Popular Posts
Visual Studio: Auto increment version
04/01/2024
What is ARM architecture?
04/01/2024