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
- If else condition in sql server
- Connection string odbc
- How to Insert Update Delete View and Search data from MySQL in C#
- How to Download and Restore Northwind database to SQL Server
- How to Download ODBC Driver for SQL Server
- Download SQL Server Management Studio (SSMS) Versions
- How to convert varchar to uniqueidentifier in SQL Server
- Connection string mysql
Categories
Popular Posts
Material Lite Admin Template
11/14/2024
Freedash bootstrap lite
11/13/2024
RuangAdmin Template
11/17/2024
Responsive Animated Login Form
11/11/2024