SHOW METHOD - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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.