How do I add comments to existing table DDL in Teradata?

ddl teradata
oscilatingcretin picture oscilatingcretin · Feb 12, 2013 · Viewed 20.1k times · Source

I am adding some new columns to a table and want to add documentation to the table DDL for future developers. How does one go about this?

Answer

Rob Paller picture Rob Paller · Feb 12, 2013

Generic Syntax:

COMMENT ON {OBJECT} {OBJECTNAME} AS '{255 characters of text};

Detailed Syntax Examples:

COMMENT ON TABLE {DATABASE}.{TABLENAME} AS '{255 characters of text}';
COMMENT ON COLUMN {DATABASENAME}.{TABLENAME}.{COLUMNNAME} AS '{255 characters of text}';
COMMENT ON USER {USERNAME} AS '{255 characters of text}';
COMMENT ON DATABASE {DATABASENAME} AS '{255 characters of text}';

Related questions

Create Teradata volatile table and select from table using isql

I am trying to submit a two-statement SQL file as a batch job to the isql utility on a Linux machine. The first statement defines a VOLATILE TABLE and the second statement is a SELECT statement against this table. The …

Read More
How to extract Stored Procedure body in Teradata

I'm trying to extract Stored procedure DDL by querying system tables. If I run the following query select * from dbc.tvm where TableKind = 'P' both fields RequestText and CreateText contain NULL. Is there any way to query Stored Procedure body …

Read More
How to delete a column from a table in MySQL

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (CountryId) ) How can I delete the column IsDeleted?

Read More