View table schema

Upon connection, the RealTime database (RTDB) schema is queried internally by the Microsoft SQL Engine. The schema is used by the Microsoft SQL Engine to parse and perform error checking on Microsoft SQL statements before it queries the actual data tables.

You can view the table schema by running any of the following Microsoft SQL commands:

• list tables;

• show tables;

• select * from oa_tables;

This command returns the full schema that details system and data tables as in the example below.