15.10 - object_kind_1 - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

A mandatory database object kind specification.

The valid specifications for object_kind_1 are not all database objects. Triggers and views, for example, are definitions of actions rather than database objects.

You must specify the following database object kinds to place a comment for the kind of object they represent:

  • COLUMN
  • FUNCTION
  • GLOP SET
  • MACRO
  • METHOD
  • PROCEDURE
  • PROFILE
  • ROLE
  • TRIGGER
  • TYPE
  • VIEW

Example: Placing a Comment

This statement specifies a description of the name column in the employee table, which is assumed to be in the current database by default because employee is not qualified with a database name:

    COMMENT ON COLUMN employee.name 
      IS 'Employee name, last name followed by first initial';

Note that because the object kind for this request is COLUMN, you must specify the keyword COLUMN for the object kind when you code it.