16.20 - SHOW METHOD - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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.