EXISTS tablename

The syntax above checks if a table exists. If exists returns the table physical name.

  • tablename: The name of the table with full path.

Practical example

Command:

EXISTS table01.table10

Output:

TABLEEXISTS :: TABLE01.TABLE10 :: True
{
ATTACHED :: TABLE02.TABLE20 :: 5C83C0E8FF8D4D929FB7E6E840561D71
ATTACHED :: TABLE03.TABLE30 :: 7E89C0E8FF8D4D840FB7E6E84056929F
}

In case if a table doesn't exist the expression returns False.