15.10 - object_kind_1 - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.