For example, you can generate DDL files for a single table or for all the tables in the schema. Generate data definition structures for database objects. You can quickly access those items in the Favorites tool window ( View | Tool Windows | Favorites). To close the documentation popup, press Escape.įind all the usages or references of a data source, table, column, or any other selected item in your source files and libraries.Īdd an item to the Favorites list. View basic information about the selected element. Specify the new name in the dialog that opens.Įdit the definition of a table, column, index, primary or a foreign key.Ĭopy the fully qualified name of the selected data source, table or column to the clipboard. Rename the selected data source, table or column. The list of options depends on which element is currently selected. To see a full list of available database objects and their icons, go to Icons for data sources and their elements.Ĭontext-menu actions appear when you right-click an object in the Database tool window.Ĭreate a new data source, role, database, schema, query console, table, column, index, a primary or a foreign key. The list of database objects depends on the selected database. Open a list of database objects that you can filter for the selected database. Open the default query console for the corresponding data source.ĭata sources and their elements (tables and table columns) For example, if you press this shortcut on a table's name in the SELECT statement, you will see the DDL of this table (the CREATE TABLE statement). This option works for tables, views, and materialized views. Open a table view of the object in the data editor. (The names of the data sources with active database connections are shown in bold.)ĭata sources with active connections and their elements
#Dbschema download not opening drivers#
Open the Data Sources and Drivers dialog to manage your data sources and their settings.Ĭlose the database connection for the selected data source or data sources. See also, Data sources and drivers dialog.
#Dbschema download not opening update#
Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). Specify the properties of the data source in the Data Sources and Drivers dialog that opens. If a DDL data source is selected, you can only choose to create another data source.Ĭreate a copy of the selected data source. The list of options depends on which element is currently selected.ĭata sources and their elements. Create a new data source, role, database, schema, query console, table, column, index, or a primary or a foreign key.
0 kommentar(er)
