Netsuite suiteQL get fields of tables and fields of views

1.2k views Asked by At

How can I get a list of fields for tables or views from NetSuite using a SuiteQL connection?

I tried select * from oa_columns where table_name = 'account'; but that did not work.

I'm using the CDATA ODBC Connector

1

There are 1 answers

1
Bart Jonk On

SELECT ColumnName FROM sys_tablecolumns WHERE TableName='Account' does the trick