|
The best way to learn more about DBGizmo is to download a free demo now! |
The DBGizmo features are organized under 17 tabs. The tab names are Home, Tables, Routines, SQL², SQL³, Notes,
Facts, About, and Grid1 through Grid 9. |
The Home tab provides database connection features, an object name search feature, a SQL code search feature,
SQL routine scripting features, and an interactive database diagram to visualize table relationships. |
The Tables tab provides a convenient way to browse table structures and parent/child relationships between tables.
It also offers several snippets of generated SQL code to work with the selected table. |
|
The Routines tab provides an informative way to review dependencies between SQL routines and other objects. It shows a Referenced By (SQL routines) list and References To (objects) lists for the selected SQL routine. |
|
The SQL² tab provides generated SQL code for a variety of purposes. There are options for creating foreign key indexes, creating CRUD stored procedures, creating tables/triggers for auditing purposes, and more. |
The SQL³ tab provides generated SQL code to reconcile rows in two databases with identical structures. There
are options to process all rows in selected tables or a set of related rows in related tables. |
|
The Notes tab provides an editor for the Notes (extended properties) of various database objects. It offers a handy means to embed useful documentation into the database for future reference. |
|
The Facts tab provides a viewer for the Facts (database properties) of all databases on the connected server. It's a simple way to compare and confirm the current configuration settings. |
|
The About tab provides contact information, usage notes, and some program configuration options. |
|
The Grid tabs display information about database structures. There are 37 different kinds of information about your tables, columns, SQL routines, constraints, indexes, search results, table relationships, and object dependencies. |
|
These features offer tremendous advantages for SQL Server database developers and administrators. |
|
|
|
The Home tab contains a set of three smaller tabs, List 1 / List 2 / List 3, in the lower left corner. |
|
These tabs contain query options (there are 10 of them on each tab) for database analysis. |
|
The query options present data sets which offer interesting ways to examine schema information. |
|
The data sets are listed below. Please refer to the DBGizmo documentation for descriptions and details. |
| List 1 |
List 2 |
List 3 |
| Free |
Tables |
L2 |
Table Column Names |
Free |
Object Name Pieces |
| Free |
Table Columns |
L2 |
Table Column Types |
Free |
Object Name Problems |
| Free |
SQL Routines |
L2 |
Table Prominence |
L1 |
Questionable Data Types |
| Free |
SQL Routine Columns |
L2 |
SQL Routine Parameter Names |
L1 |
Questionable SQL Routines |
| L1 |
SQL Routine Parameters |
L2 |
SQL Routine Parameter Types |
L2 |
Questionable SQL References |
| L1 |
Key Constraints, Primary |
L2 |
SQL Routine Prominence |
L2 |
Questionable Parameters |
| L1 |
Key Constraints, Another |
Free |
Users, Names/Access |
L2 |
Questionable Indexes |
| L1 |
Key Constraints, Foreign |
Free |
Object Permissions |
L2 |
Index Redundancy |
| L1 |
Indexes, Key/Performance |
Free |
Table Partitions |
L1 |
Index Column Summary |
| L1 |
Indexes, Summary |
Free |
Files, Data/Log |
L1 |
SQL Code Cross References |
|
|
|
