15.00 - Restrictions - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Restrictions

The following restrictions apply to SHOW:

  • The statement cannot be used as part of a multistatement request. It can be issued only as a standalone request.
  • The USING request modifier cannot precede a SHOW request.
  • DML_statement is limited to the following SQL DML statements:
  • DELETE
  • INSERT
  • INSERT … SELECT
  • MERGE
  • SELECT
  • UPDATE
  • The objects referenced in DML_statement must have valid object names. For example, SHOW SELECT 1 is not a valid request and returns an error.
  • If an object contains UDTs, the SHOW statement does not report the DDL for its casting, ordering, or transform functionality.
  • To view those DDL statements, you must use the SHOW TYPE statement (see “SHOW object” on page 993).