Wednesday, October 24, 2018

Sample SQL Query to List All Table Views from NetSuite ODBC Account

Sample SQL query to list all Table views from NetSuite ODBC account


Answer:

SELECT * FROM OA_TABLES


-OA_TABLES is a system audit table that lists all the available table views of a NetSuite  account.  This table is hidden by default when viewing the schema catalog.

No comments:

Post a Comment