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)
#DATAGRIP MS SQL SERVER UPDATE#
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
#DATAGRIP MS SQL SERVER 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. 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. The following video presents a short overview of the Database Explorer tool window.Ĭ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 DataGrip, refer to the Database objects section. Once DataGrip is connected to a database, Database Explorer will display the introspected and downloaded database objects.
#DATAGRIP MS SQL SERVER HOW TO#
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 Explorer ( View | Tool Windows | Database Explorer), you can work with databases and DDL data sources.
0 kommentar(er)
