.05 Database Explorer
- Former user (Deleted)
- Former user (Deleted)
Database Explorer
The Database Explorer provides the ability to explore configured database connections. The Database Explorer also supports tables, views, and synonyms along with the catalog and/or schema to which the table belongs.
The buttons to the right provide quick access the following features for the selected table:
Feature |
Description |
|---|---|
Preview first 100 rows of... |
Returns the first 100 rows from the selected table |
Preview first ... rows of... |
Prompts the user for the number of rows to return from the selected table |
Number of rows... |
Specifies the three digit client number for the connection |
Show Layout of... |
Displays a list of column names, data types, and so on from the selected table |
Generate DDL |
Generates the DDL to create the selected table based on the current connection type |
Generate DDL for other connection |
Prompts the user for another connection, then generates the DDL to create the selected table based on the user selected connection type. |
Open SQL for... |
Launches the Simple SQL Editor for the selected table |
Truncate table... |
Generates a TRUNCATE table statement for the current table.
|