DB Admin for SQL connections

DB Admin provides a way to analyze and edit the metadata for SQL connections. It supports SQL Server, Access, MySql, Oracle and BD2.



Databases

You can delete a database and see how much space each database takes.


You can create a database.







Tables

You can see a tree map of a database to see which tables have data and how much.


You can see which tables have data and how much.


You can create a table.







Table

You can see which column is used by which index.


You can see table data.


You can see the distinct count of a column to identify the dimensional cardinality and top 1000 distinct records and their counts.


You can see foreign key (FK) relationships between this table and other tables. FK relationships can also be deleted or disabled. You can also navigate between table.


You can see check constraints and lets you create new check constraints.


You can view and modify table security.


You can view and modify table statistics.


You can add a new column.


You can add a new index.


You can export table data to different (CSV, Excel, HTML, XML , SQL) formats.


You can import table data.







Column

You can view column settings.


You can view column data summary.


You can view and modify column security.


You can view and modify column statistics.







Views

You can view and delete views.


You can view a view code and data and modify it and its security.







Stored Procedure

You can view and delete stored procedures.


You can view a stored procedure and modify it.







Functions

You can view and delete functions.


You can view a function and modify it.







Triggers

You can view and delete triggers.


You can view a trigger and modify it.







Users

You can view and modify database users.


You can view security and roles for a database user.


You can create a database user.


You can add and remove roles to a database user.







Roles

You can view and modify Roles.







Sessions

You can view and modify active user sessions.







Logins

You can view and modify logins.







Index Usage

Index Usage lets you identify unused indexes and delete them.