Wednesday, October 24, 2018

ODBC Query that Lists Table Structure from NetSuite


Image

Sample SQL query to  verify the Table Structure 

Answer:

 SELECT * FROM OA_COLUMNS WHERE TABLE_NAME='{tablename}'


- OA_COLUMNS is a system audit table that list all the table structure of a NetSuite  account.  This table is default hidden when viewing the schema catalog.

1 comment: