Is there a query to get a list of all tables?
# suiteqlc
Chris
04/10/2023, 2:42 PMIs there a query to get a list of all tables?
n
Nathan L
04/10/2023, 2:50 PMTheres the records catalog that shows all the tables.
Customization > Records Catalog
Theres also this really cool tool that Tim Dietrich developed for searching tables and running sample queries
https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/
Nathan L
04/10/2023, 2:51 PMI also found this, which actually answers your question.
http://www.netsuiterp.com/2018/10/sample-sql-query-to-list-all-table.html
SELECT * from OA_TABLESc
Chris
04/10/2023, 2:54 PMGot this when running that query
Invalid search type: OA_TABLESChris
04/10/2023, 2:55 PMThere has to be a way to run this query. Getting info about the db is so basic!
n
Nathan L
04/10/2023, 2:55 PMah looks like it may only work with ODBC
Youre right. It seems like such a simple thing
Nathan L
04/10/2023, 2:57 PMhttps://timdietrich.me/blog/netsuite-suiteql-tables-permissions-reference/
Heres another reference but still no query
c
Chris
04/10/2023, 3:10 PMDoesn't look like it's exposed to regular SuiteAnalytics. 😞
😩 1
j
jen
04/10/2023, 3:34 PMNote that the Records Catalog is NOT complete.
jen
04/10/2023, 3:34 PMa glaring example,
transactionlinejen
04/10/2023, 3:34 PMmessage has been deleted
n
Nathan L
04/10/2023, 3:34 PMoof
j
jen
04/10/2023, 3:35 PMeven though it does exist (you can modify the URL to get to it)
jen
04/10/2023, 3:35 PMe.g.
<https://xxxxx.app.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/transactionline>n
Nathan L
04/10/2023, 3:35 PMThats why i really like that SuiteQL tool by Tim. It has a comprehensive list with links to all the joins on the record
j
jen
04/10/2023, 3:36 PMYeah it’s cool. I haven’t used it yet as I wrote my own Query runner, and I already know pretty much all the tables I need.
jen
04/10/2023, 3:36 PMMine is not as fancy 😉
jen
04/10/2023, 3:37 PMbut does the trick
n
Nathan L
04/10/2023, 3:38 PMOh wow. That looks impressive
j
jen
04/10/2023, 5:13 PMit’s just a suitelet
jen
04/10/2023, 5:13 PMI do like that I log all the queries that I run though…has saved me before cuz I can go back and find something I wrote before
a
Alan Fitch
04/10/2023, 5:16 PMBig problem with SuiteQL that greatly limits the tools you are able to create. I've created a SuiteQL vscode extension but without a way to access the schema I found myself reaching for @tdietrich's tool often enough to drop development.
c
Chris
04/10/2023, 7:43 PMThere are tables you can query that aren't in the records browser, that's the problem I'm running into. Try finding a reference to the
ItemImages
Shai Coleman
04/11/2023, 9:05 PMYou can find most of the tables in analytics browser documentation.
https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/itemImage.html
But that is also missing some tables, e.g. the
transactionstatusShai Coleman
04/11/2023, 9:07 PMI've put it together into an Excel spreadsheet which you can filter/search
👀 1
c
Chris
04/19/2023, 8:07 PM@Shai Coleman This is a gold mine of good info.
47 Views