This information might be helpful when introspection works incorrectly. Introspector.txt: a module that was used to load the metadata from the database. Generate three files that include information about the following: This information might be helpful for the support team when your introspection takes too much time.ĭiagnostics | Prepare Introspector Diagnostics Reload the metadata from the database and generate a detailed log file of the process. This information might be helpful for the support team if some database objects exist in the database but do not show up in the Database tool window. Generate a diagnostic representation of the database in a PhpStorm internal format. Remove the primary key constraint for the current table. CREATE LINK IN IDATABASE DRIVERSOpen the Data Sources and Drivers window where you can customize data source settings. To check if this has eliminated the problem, use the Synchronize command. Use this command when you experience issues like wrong display of data structures or errors during synchronization. This action is available on the data source node only. This action is available on the data source node only.ĭelete the information that PhpStorm has accumulated about your database. Open a popup with available schemas for the current data source.ĭelete the data source information from cache and load it again. Remove all the rows in the selected table. Modify or add a comment to a database object like if you have run the following query COMMENT ON SCHEMA information_schema IS 'm圜omment'. Generate DDL of the object and paste it to a query console. SQL Scripts | Generate DDL to Query Console Generate DDL of the object and copy it to the clipboard. If your database stores DDL of the object, retrieve DDL from the database. SQL Scripts | Request and Copy Original DDL 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. CREATE LINK IN IDATABASE WINDOWSYou 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. CREATE LINK IN IDATABASE FULLTo 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 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. CREATE LINK IN IDATABASE UPDATEUpdate 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |