How to use Oracle linked server shows all tables
By FoxLearn 5/15/2024 9:04:50 AM 105
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 export data to .csv file
- How to Read Excel file and Import data from Excel to SQL Server in C#
- How to Create a backup SQL Server in C#
- How to Search data from Database in C#
- How to rename a column name in SQL
- How to add primary key to existing table in SQL Server
- How to add index in SQL Server
- How to Download and Restore Northwind database to SQL Server
Categories
Popular Posts
C# Tutorial
07/20/2024
How to Download Microsoft SQL Server
06/22/2024
What Are RESTful Web Services?
02/19/2024
What is ARM architecture?
04/01/2024