Aster Foreign server Definition

Aster
Highlighted
pk
Fan

Aster Foreign server Definition

How to get the already defined Foreign Servers from Aster Database? By query or via Teradata Studio .... either way it's fine.

Tags (1)

Accepted Solutions
Teradata Employee

Re: Aster Foreign server Definition

To get all existing foreign servers, login as admin user e.g. db_superuser and run the following query via ACT or TD Studio:
select * from nc_system.nc_all_foreign_servers;

 

To view foreign server definition run the following query:

 display foreign server fs_name;

 

 

1 ACCEPTED SOLUTION
1 REPLY 1
Teradata Employee

Re: Aster Foreign server Definition

To get all existing foreign servers, login as admin user e.g. db_superuser and run the following query via ACT or TD Studio:
select * from nc_system.nc_all_foreign_servers;

 

To view foreign server definition run the following query:

 display foreign server fs_name;