(The Database Color Settings dialog will open.) Set or change the color for the selected element or elements. Search for data in your databases or a group of databases without knowing data exact location.įor more information about the full-text search, see Full-text search in databases. The comparison results are shown in the differences viewer. Open a popup with available schemas for the current data source.Ĭompare structures of two selected database objects (data sources, schemas, or tables). Remove all the rows in the selected table. Generate DDL of the object and copy it to the clipboard. For example, you can set what syntax to use for table creation: CREATE TABLE or CREATE TABLE IF NOT EXISTS. Also, you can customize generation settings. 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. Children inherit a level that is set for a parent. To close the documentation popup, press Escape.ĭata source elements: functions, procedures.Ĭhange the introspection level either for the whole database or for a particular schema. View basic information about the selected element. Specify the new name in the dialog that opens.Ĭ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 list of query consoles for the selected data source.ĭata sources and their elements (tables and table columns) Update the source code of database objects by directly editing their DDL CREATE scripts and submitting your changes in the editor. 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 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. 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. Controls on the toolbarĬreate a new data source, role, database, schema, query console, table, column, index, or a primary or a foreign key. If the toolbar is hidden, the Refresh and Open Query Console commands can be access by means of the title bar icons ( and respectively). (If the toolbar is not currently shown, click on the title bar and select Show Toolbar.) Many of the commands have keyboard shortcuts. Most of the functions in this window are accessed by means of the toolbar icons or context menu commands. To learn more about working with database objects in P圜harm, refer to the Database objects section. Once P圜harm is connected to a database, Database tool window will display the introspected and downloaded database objects. For information on how to connect to a database, refer to the Create connection section. If no data sources are currently defined, use the New command Alt+Insert to create a data source and connect to a database. The available data sources are shown as a tree of data sources, schemas, tables and columns. You can view and modify data structures in your databases, and perform other associated tasks. In the Database tool window ( View | Tool Windows | Database), you can work with databases and DDL data sources.
0 Comments
Leave a Reply. |