TABLESLIST

The syntax above lists all the existing tables in the database with living assignments.

Practical example

Command:

TABLESLIST

Output:

TABLES :: ROOT
{
TABLE01
TABLE01.TABLE10
TABLE01.TABLE10.TABLE20
TABLE02
TABLE02.TABLE20
TABLE03
}



TABLESLIST tablename

The syntax above lists all the existing tables under the desired table with living assignments.

  • tablename: The name of the table we want to list the existing tables under.

Practical example

Command:

TABLESLIST table01

Output:

TABLES :: TABLE01
{
TABLE01
TABLE01.TABLE10
TABLE01.TABLE10.TABLE20
}



TABLESLIST [id]

The syntax above lists all the existing tables in database with living assignments. More tables may be visible than using the first expression (TABLESLIST), because under one similar table name can be multiple assigned tables. See more at ASSIGN and RENAME pages.

  • id: Indicates that we want list the existing table's IDs.

Practical example

Command:

TABLESLIST [id]

Output:

TABLES :: ROOT
{
TABLE01=BCE7F9E8E6734FB0A170EE1948FEBB8F
TABLE02=50F8CAA2F5DA432A9631A18C2772D9B2
TABLE03=8302D9BFBE494BEAB9B4103181BFB9A5
TABLE01.TABLE10=2C4B058238444A9EA5D1EB39928A3F2C
TABLE02.TABLE20=AF4841ECFAFA4E13A9C61374866B49B7
TABLE01.TABLE10.TABLE20=AF4841ECFAFA4E13A9C61374866B49B7
TABLE10, 1=5E93D8E46DED446C8588127B24E8C621
TABLE01.TABLE10, 1=5E93D8E46DED446C8588127B24E8C621
TABLE01.TABLE20=BF4132EBA53345E6988BBF17173AC798
TABLE03.TABLE20=BF4132EBA53345E6988BBF17173AC798
TABLE03.TABLE20=AF4841ECFAFA4E13A9C61374866B49B7
}