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.
select * from oa_columns where table_name = 'account';
I'm using the CDATA ODBC Connector
SELECT ColumnName FROM sys_tablecolumns WHERE TableName='Account' does the trick
SELECT ColumnName FROM sys_tablecolumns WHERE TableName='Account'
SELECT ColumnName FROM sys_tablecolumns WHERE TableName='Account'
does the trick