RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-comment below:

COMMENT ON | Databricks Documentation

COMMENT ON

Applies to: Databricks SQL Databricks Runtime

Sets a comment on a catalog, schema, table, column, share, recipient, provider, or volume.

Catalogs, shares, recipients, and providers are supported in Unity Catalog only.

Syntaxâ

COMMENT ON
    { CATALOG catalog_name |
      COLUMN relation_name . column_name |
      CONNECTION connection_name |
      PROVIDER provider_name |
      RECIPIENT recipient_name |
      { SCHEMA | DATABASE } schema_name |
      SHARE share_name |
      TABLE relation_name |
      VOLUME volume_name }
    IS comment

Parametersâ

catalog_name

The name of the catalog where your comment appears. To run this statement, you must be the owner of the catalog or have the MANAGE privilege on it.
relation_name . column_name

Applies to: Databricks SQL Databricks Runtime 16.1 and above

The qualified name of the column you comment on. relation_name must identify a view or a table. The relation_name must not include a temporal specification or options specification.

If you use Unity Catalog, to run this statement, you must have:
- MODIFY privilege on the table.
- be the OWNER of the view.
connection_name

Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above Unity Catalog only

The name of the connection where your comment appears. To run this statement, you must be the owner of the connection or have the MANAGE privilege on it..
schema_name

The name of the schema where your comment appears.

If you use Unity Catalog, to run this statement, you must be the owner of the schema or have the MANAGE privilege on it.
relation_name

The name of the table, or view, that you comment on. The table name must not include a temporal specification or options specification.

If you use Unity Catalog, to run this statement, you must have:
- MODIFY privilege on the table.
- be the OWNER of the view.
share_name

Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above

The name of the share where your comment appears. To run this statement, you must be the owner of the share.
recipient_name

Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above

The name of the recipient where your comment appears. To run this statement, you must be the owner of the recipient.
provider_name

Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above

The name of the provider where your comment appears. To run this statement, you must be the owner of the provider.
volume_name

Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above

The name of the volume where your comment appears. To run this statement, you must be the owner of the volume or have the MANAGE privilege on it..
comment

A STRING literal or NULL. If you specify NULL any existing comment is removed.

Examplesâ

> COMMENT ON CATALOG my_catalog IS 'This is my catalog';

> COMMENT ON COLUMN my_table.c1 IS 'This is my column';

> COMMENT ON CONNECTION mysql_connection IS 'this is a mysql connection';

> COMMENT ON SCHEMA my_schema IS 'This is my schema';

> COMMENT ON TABLE my_table IS 'This is my table';

> COMMENT ON TABLE my_table IS NULL;

> COMMENT ON SHARE my_share IS 'A good share';

> COMMENT ON RECIPIENT my_recipient IS 'A good recipient';

> COMMENT ON PROVIDER my_provider IS 'A good provider';

> COMMENT ON VOLUME my_volume IS 'Huge volume';