To have better differentiation between production and test databases, you can assign a color to a data source. The cut operation can be undone by using Control+Z. But the password is required in all the other cases. If you cut and paste a data source inside one project, it will be just moved, no password is required. To remove a data source from the folder, select Root folder.Īlso, you can use Control+C, Control+V, and Control+X to copy, paste, and cut your data sources between folders. To create a new folder, select New Folder. If you have folders with grouped data sources, you will see the Move to Folder dialog. For example, the QA/Quick name will create the Quick folder inside the QA folder. You can use a forward slash ( /) to define nesting. If you do not have any folders, you will see the New Folder dialog. Alternatively, right-click a data source and select Move to Folder. In the Database tool window ( View | Tool Windows | Database), select the necessary data source and press F6. In the Database tool window ( View | Tool Windows | Database), the view of the data source changes instantly.įor more information about the view options, refer to View options. To group, enable, or sort data sources, click the Options icon ( ) on the title bar of the Database tool window and select the necessary options. Customize the view of objects in the Database tool window You can group, assign a color, and filter objects in the Database tool window ( View | Tool Windows | Database). To create a DDL data source, follow the instructions from the DDL data sources topic.Ĭonfigure display options for data sources PhpStorm provides a complete support for the following database vendors:įor the database vendors listed below, a basic support is provided: To connect to a database and start working with it, create a data source that will contain the connection details, and specify those details for the database that you are connecting to.įollow the instructions for the database vendor. Whereas basic support has limited features available.įor more information on the support types, refer to the Other databases topic.ĭata Definition Language (DDL) data sources: SQL files that contain data definition language statements (refer to DDL data sources). All the inspections, quick-fixes, and other code assistance features are also available. Complete support of a database vendor includes such features as enhanced code completion and better retrieval of database objects (introspection). In PhpStorm, you can create the following data sources:ĭatabase data sources: connection configurations for the operational databases that contain data.įor different database vendors, PhpStorm provides complete support and basic support. Data sources with an active connection to a database are marked with a green dot in the corner of their icons. You can see the list of created data sources in the Database tool window ( View | Tool Windows | Database). To access the dialog, in the Database tool window ( View | Tool Windows | Database), click the Data Source Properties button ( ) on the toolbar. ![]() You can configure your data sources in the Data Sources and Drivers dialog ( Command I). In data source settings, you can also select databases and schemas for introspection and display in Database tool window, and change the driver for your connection. For example, host, port, database name, driver, SSH and SSL configuration settings, and so on. It stores a list of connection details that are used to establish connection to a database. Data source is a connection configuration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |