Explains how to explore configured database connections.
The Database Explorer allow you to explore configured database connections. The Database Explorer also supports tables, views, and synonyms along with the catalog, schema, or both to which the table belongs.
A right-click on the selected table provides quick access to the following features:
|Preview first 100||Returns the first 100 rows from the selected table|
|Preview x Rows||Prompts you for the number of rows to return from the selected table|
|Row Count||Specifies the total number of rows in the selected table|
|Show Layout||Displays a list of column names, data types, and so on from the selected table|
|DDL||Generates the DDL to create the selected table based on the current connection type; the drop-down|
|View SQL||Launches the Simple SQL Editor for the selected table|
|Truncate Table||Generates a TRUNCATE table statement for the current table |
Note: The statement is commented out by default to prevent users from accidentally deleting the table data
|Model||Switches to the Model perspective for the selected table|
|Visualize||Switches to the Visualize perspective for the selected table|