{Denodo}DESC ステートメント

https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/describing_catalog_elements/describing_catalog_elements
https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands

DESC QUERYPLAN select * from i_tab1;
DESC CATALOG_DATABASE;
DESC SESSION;

DESC VQL DATABASE db01 ('includeCreateDatabase' = 'yes', 'replaceExistingElements' = 'yes');
DESC VQL FOLDER '/03iv' ('includeContents' = 'yes', 'includeDependencies' = 'no');
DESC VQL DATASOURCE JDBC ds01 ('replaceExistingElements' = 'yes', 'includeDependencies' = 'yes');

<data source type> ::= CUSTOM | DF | ESSBASE | JDBC | JSON | LDAP | ODBC | OLAP | SALESFORCE | SAPBWBAPI | SAPERP | WS | XML }

※data source typeは下記クエリで取得可能
select * from GET_ELEMENTS() where database_name = 'db01' and name = 'ds01' and type = 'datasource';

DESC VQL VIEW b_tab1 ('replaceExistingElements' = 'yes', 'includeDependencies' = 'no');
DESC VQL VIEW i_tab1 ('replaceExistingElements' = 'yes', 'includeDependencies' = 'yes');
DESC VQL WRAPPER jdbc b_tab1 ('replaceExistingElements' = 'yes', 'includeDependencies' = 'no');
DESC VQL ROLE serveradmin;
DESC VQL TAG tag01;
DESC VQL USER admin;

DESC DATABASE db01;
DESC DATASOURCE JDBC ds01;
DESC ROLE serveradmin;
DESC USER admin;
DESC VIEW b_tab1;
DESC WRAPPER jdbc b_tab1;

DESC VQL LIST VIEW db01.b_tab1 (
 'replaceExistingElements' = 'yes',
 'includeDependencies' = 'no');
 
DESC VQL LIST VIEW db01.b_tab1 (
 'replaceExistingElements' = 'yes',
 'includeDependencies' = 'yes');

DESC VQL LIST VIEW db01.b_tab1 (
 'replaceExistingElements' = 'yes', 
 'includeDependencies' = 'yes',
 'includeProperties' ='yes');

DESC VQL LIST VIEW db01.b_tab1 (
 'replaceExistingElements' = 'yes',
 'includeDependencies' = 'yes',
 'includeProperties' ='yes',
 'exclude_jdbc_wrapper_properties' = 'yes');

DESC VQL LIST VIEW db01.b_tab1, DATASOURCE JDBC db02.ds01 (
 'replaceExistingElements' = 'yes',
 'includeDependencies' = 'yes',
 'includeProperties' ='yes',
 'exclude_jdbc_wrapper_properties' = 'yes');