Get the Meta Data of ODBC fields to verify the field type and field lengths

 

Users can query the meta data of ODBC fields/columns to know their corresponding field types and field lengths by querying the OA_COLUMNS table:
 
SELECT * FROM OA_COLUMNS

ODBC includes SYSTEM TABLES that are not indicated on the Help Guide but is helpful to users who wants to migrate NetSuite data to other database. The SYSTEM TABLES available in ODBC are:
 
OA_COLUMNS
OA_FLKEYS
OA_INFO
OA_PROC
OA_PROCCOLUMNS
OA_STATISTICS
OA_TABLES
OA_TYPES