HELP DATABASE | VantageCloud Lake - HELP DATABASE - Teradata Vantage

Teradata® Open Table Format for Apache Iceberg and Delta Lake User Guide
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
20.00
Published
October 2025
ft:locale
en-US
ft:lastEdition
2025-10-25
dita:mapPath
qrj1749167830193.ditamap
dita:ditavalPath
lli1749584660955.ditaval
dita:id
bsr1702324250454

The HELP DATABASE statement can be used to list the tables in a datalake database. The datalake and database name must be specified in the <datalake_name>.<database_name> format.

Columns Returned

  • Table/View/Macro Name
  • Kind
  • Comment
  • Protection
  • Creator Name
  • Commit Option
  • Transaction Log
  • Table/View/Macro Dictionary Name
  • Table/View/Macro SQL Name
  • Table/View/Macro UEscape Name
  • Creator Dictionary Name
  • Creator SQL Name
  • Creator SQL UEscape
  • Table Flavor
  • TblProperties
  • OTF Table Format

Syntax

HELP DATABASE <datalake_name>.<database_name>;

Example: Iceberg

HELP DATABASE datalake_iceberg_glue.testdb;
*** Help information returned. 1 row found.
*** Total elapsed time was 1 second.

Table/View/Macro Name tab1
Kind T Comment ?
Protection ? Creator Name ?
Commit Option ? Transaction Log ? Table/View/Macro Dictionary Name tab1
Table/View/Macro SQL Name tab1
Table/View/Macro Name UEscape ? Creator Dictionary Name ?
Creator SQL Name ?
Creator SQL UEscape ? Table Flavor I TblProperties 'teradata.purge.all'='true','write.object-storag
OTF Table Format iceberg

Example: Delta Lake

HELP DATALAKE datalake_deltalake_test.testdb;
*** Help information returned. 1 row found.
*** Total elapsed time was 1 second.

Table/View/Macro Name logtbl
Kind T Comment ?
Protection ? Creator Name ?
Commit Option ? Transaction Log ? Table/View/Macro Dictionary Name logtbl
Table/View/Macro SQL Name logtbl
Table/View/Macro Name UEscape ? Creator Dictionary Name ?
Creator SQL Name ?
Creator SQL UEscape ? Table Flavor I TblProperties 'delta.lastCommitTimestamp'='1743097751000','del
OTF Table Format deltalake