How to use Oracle linked server shows all tables
By FoxLearn 5/15/2024 9:04:50 AM 218
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 convert varchar to uniqueidentifier in SQL Server
- Connection string mysql
- How to convert string to datetime in SQL
- How to Download and Restore Northwind database to SQL Server
- Download backup of Northwind database for SQL Server
- Download AdventureWorks sample database for SQL Server
- Download SQL Server Management Studio (SSMS) Versions
- How to Download SQL Server Management Studio (SSMS) Versions
Categories
Popular Posts
Spica Admin Dashboard Template
11/18/2024
