Connection Factory tables
Answered
Is there a resource somewhere with a list of all ConnectionFactory.getFactory().getConnection() tables out there in Agile?
I know of these SQL tables already, each with their own column names:
CHANGE, USER_USAGE_HISTORY, ITEM, REV, PAGE_TWO, PAGE_THREE, AGILE_FLEX, LISTENTRY, NODETABLE, AGILEUSER, ITEM_HISTORY, and CHANGE_HISTORY tables
Are there any less obvious ones I’m missing? I couldn’t find anything in the Agile guides.
Best answer
Oh, nevermind. There’s 584 database tables in Agile – too many to list here. I got the list by using.
statement = connection.prepareStatement(“SELECT table_name FROM user_tab_cols”);