Display - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

This command obtains the DDL of a single database object and returns the DDL as a string.

DISPLAY [IN JSON] {TABLE | VIEW | INDEX | DATABASE | SCHEMA | USER | ROLE | INSTALLFILE} <database object name>;

This is an example:

display in json table myschema.mytable;