You can translate the question and the replies:

Source table

How can i get the list of tables in the source (the source has already connected to Denodo) ?
Data Source table
user
30-06-2023 06:06:47 -0400
code

3 Answers

Hi, you can use the stored procedure [GET_JDBC_DATASOURCE_TABLES](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_jdbc_datasource_tables). For example: ``` # Mysql SELECT * FROM GET_JDBC_DATASOURCE_TABLES() WHERE input_datasource_name = '<data_source_name>' and input_catalog_name = '<database_name>'; ``` ``` # Oracle SELECT * FROM GET_JDBC_DATASOURCE_TABLES() WHERE input_datasource_name = '<data_source_name>' and input_schema_name = '<schema_name>'; ``` Hope this helps
Denodo Team
30-06-2023 10:38:29 -0400
code
Can I get list of table in the source that didn't created base view in Denodo?
user
01-07-2023 23:47:14 -0400
Sure, the sample code should already show all the tables of the specified datasource, even the ones without a corresponding base view in Denodo. Make sure you're filtering with the right clause (e.g. input_schema_name for Oracle, input_catalagon_name for mysql, etc.). Hope this helps.
Denodo Team
03-07-2023 04:04:13 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here