15.10 - object_kind_2 - 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

An optional database object kind specification.

You can specify the following database object kinds to retrieve a comment for the kind of object they represent, but they are optional.

  • DATABASE
  • FILE

    If you do not specify FILE for a user-installed file (UIF), you must specify the database name.

  • TABLE

    If you specify an object kind, you must specify the keyword TABLE for any hash or join index to place a comment on the object. However, because TABLE is not a mandatory object kind specification, you are not required to specify it.

  • USER