17.10 - SHOW METHOD - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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.