[ https://issues.apache.org/jira/browse/TRAFODION-3104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16511304#comment-16511304 ]
ASF GitHub Bot commented on TRAFODION-3104: ------------------------------------------- Github user robertamarton commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1605#discussion_r195129619 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc --- @@ -5268,95 +5268,99 @@ displays a list of all the existing components. displays the names of all the user-defined functions (UDFs) in the catalog and schema of the current session. By default, the catalog is TRAFODION, and the schema is SEABASE. -* `FUNCTIONS FOR LIBRARY \[[_catalog-name_.]_schema-name_.]_library-name_` +* `FUNCTIONS FOR LIBRARY _[[catalog-name.]schema-name.]library-name_` + displays the UDFs that reference the specified library. -* `functions in schema [_catalog-name_.]_schema-name_` +* `FUNCTIONS [IN SCHEMA _[catalog-name.]schema-name_` + displays the names of all the UDFs in the specified schema. -* `libraries` +* `LIBRARIES` + displays the names of all the libraries in the catalog and schema of the current session. By default, the catalog is trafodion, and the schema is seabase. -* `libraries in schema [_catalog-name_.]_schema-name_` +* `LIBRARIES [IN SCHEMA _[catalog-name.]schema-name_` + displays the libraries in the specified schema. -* `procedures` +* `PROCEDURES` + displays the names of all the procedures in the catalog and schema of the current session. By default, the catalog is trafodion, and the schema is seabase. -* `procedures for library \[[_catalog-name_.]_schema-name_.]_library-name_` +* `PROCEDURES FOR LIBRARY for _[[catalog-name.]schema-name.]library-name_` + displays the procedures that reference the specified library. -* `procedures in schema [_catalog-name_.]_schema-name_` +* `PROCEDURES [IN SCHEMA _[catalog-name.]schema-name_` + displays the names of all the procedures in the specified schema. -* `roles` +* `ROLES` + displays a list of all the existing roles. -* `roles for user _database-username_` +* `ROLES [FOR USER _database-username_]` + displays all the roles that have been granted to the specified database user. The _database-username_ can be a regular or delimited case-insensitive identifier. see <<case_insensitive_delimited_identifiers,case-insensitive delimited identifiers>>. -* `schemas` +* `SCHEMAS` + displays the names of all the schemas in the catalog of the current session. By default, the catalog is trafodion. -* `schemas in catalog _catalog-name_` +* `SCHEMAS [IN CATALOG _catalog-name_]` + displays the names of all the schemas in the specified catalog. For the _catalog-name_, you can specify only trafodion. -* `schemas for [user | role] _authorization-id_` +* `SCHEMAS FOR [USER | ROLE] _authorization-id_` + displays all the schemas managed (or owned) by a specified user or role. -* `_authorization-id_` +** `_authorization-id_` + is the name of a user or role. you may specify either user or role for users or roles. -* `tables` +* `TABLES` + displays the names of all the tables in the catalog and schema of the current session. By default, the catalog is trafodion, and the schema is seabase. -* `tables in schema [_catalog-name_.]_schema-name_` +* `TABLES [IN SCHEMA _[catalog-name.]schema-name_` + displays the names of all the tables in the specified schema. -* `users` +* `USERS` + displays a list of all the registered database users. -* `users for role _role-name_` +* `USERS [FOR ROLE _role-name_]` + displays all the database users who have been granted the specified role. The _role-name_ can be a regular or delimited case-insensitive identifier. For more information, see <<case_insensitive_delimited_identifiers,case-insensitive delimited identifiers>>. <<< -* `views` +* `VIEWS` + displays the names of all the views in the catalog and schema of the current session. By default, the catalog is trafodion, and the schema is seabase. -* `views in schema [_catalog-name_.]_schema-name_` +* `VIEWS [IN SCHEMA _[catalog-name.]schema-name_` + --- End diff -- Need an ending "]" > Add Syntax Descriptions for *GET Statement* and Fix Typos in *Trafodion SQL > Reference Manaul* > --------------------------------------------------------------------------------------------- > > Key: TRAFODION-3104 > URL: https://issues.apache.org/jira/browse/TRAFODION-3104 > Project: Apache Trafodion > Issue Type: Documentation > Reporter: Liu Yu > Assignee: Liu Yu > Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)