A general question about SuiteQL. I have started ...
# general
r
A general question about SuiteQL. I have started to use SuiteQL as a tool to quickly take a look at the actual content of some tables. Is there a command that will work in the SuiteQL Query Tool editor window that will return a list of all Tables in the currently connected data source? I have attempted to use SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE'; or just Show Tables but these have not worked.
a
Alternatively you can go Setup -> Record Catalog to view all the tables in NetSuite UI.
b
The SuiteQL Query Tool also has a
Tables Reference
button at the top that provides access to schema info.