15.00 - SHOW METHOD - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

SHOW METHOD

This statement displays the create text for the SQL CREATE METHOD statement that created the body of the specified instance or constructor method.

The SHOW METHOD report does not show any method characteristics that are specified in the associated CREATE TYPE request create text. To view these characteristics, you must submit an appropriate SHOW TYPE request.

SHOW METHOD is not intended to be used to return the create text for any of the system‑generated instance observer or mutator methods because no CREATE METHOD request was performed to create them. As a result, there is no create text that can be reported for system‑generated methods.

If you submit a SHOW METHOD request on an observer or mutator method, the request aborts and the system returns an error to the requestor.

If a method signature was created as part of CREATE TYPE or ALTER TYPE statement, but a corresponding CREATE METHOD statement has not been submitted at the time you submit a SHOW METHOD request for it, the request aborts and the system returns an error to the requestor.