[DADMINUI-10] Add Schema Support to FlexSQLAdmin

[dynamobi-build]

[reporter="ngoodman", created="Thu, 4 Mar 2010 21:59:51 -0800", resolved="Thu, 10 Jun 2010 09:23:31 -0700"]

Make changes to FlexSQLAdmin to support view tables/views from multiple schemas

Adjust the UI such that:

• (above the object browser, next to the Refresh) there is a new "Drop down" that will have the list of Catalogs. The default catalog is LOCALDB.
• Adjust the UI so that the trees of objects look like:

SCHEMA1

• Tables
• - Table1
• - Table2
• Views
• - View1
  SCHEMA2
• Tables
• - Table2
• - Table9
• Views

• Adjust the UI such that each table has both schema/tablename. Adjust the "generate SELECT" and "generate INSERT" menu items so that it properly quotes the identifiers. ie, "SCHEMA1"."Table9"

[dynamobi-build]

[author="rzhang", created="Fri, 12 Mar 2010 01:17:12 -0800"]

I am reviewing the code of flexadminsql.

[dynamobi-build]

[author="ngoodman", created="Sun, 14 Mar 2010 11:07:55 -0700"]

The video for DWS-8 shows the schema tree working in FlexSQLAdmin. Make sure the new schema prefix is carried through for SELECT/INSERT and into table editor.

Ie, "script as Select..." should yield a table from clause like:

from "ScheMANameWithQuotes"."TableOrVIEWNamewithQuotes"

[dynamobi-build]

[author="rzhang", created="Mon, 29 Mar 2010 07:43:41 -0700"]

All code were checked by today.
Please sync up and play some rounds.

[dynamobi-build]

[author="ngoodman", created="Thu, 10 Jun 2010 09:23:31 -0700"]

Done