dynamobi/adminui — Issue #49: [DADMINUI-10] Add Schema Support to FlexSQLAdmin
Author: dynamobi-build
Created: 2011-12-30 01:17:07+00:00
State: closed
Labels: Screens

[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"