Skip to content

Database Explorer

The "Database Explorer" in the Databases perspective is a powerful tool for managing and interacting with databases. This section provides an overview of the key features and actions available in the "Database Explorer."

Database Explorer

Connecting to a Database

  1. Open the Database Explorer:

  2. Navigate to the Databases perspective and select "Database Explorer" tab.

  3. Explore Connected Databases:

  4. Once connected, the Database Explorer displays a list of connected databases. Expand the nodes to view tables, views, procedures, and other database objects.

Interacting with Relational Database Objects

Explore RDBMS

  1. View Table Data:

  2. Double-click on a table to view its data. Use the grid to edit, filter, and sort records.

  3. Execute SQL Queries:

  4. Execute custom SQL queries by right-clicking on the database, selecting "Execute SQL," and entering your query.

  5. Explore Schema Objects:

  6. Navigate through the database schema to explore tables, views, indexes, procedures, and other objects.

  7. Manage Indexes and Constraints:

  8. Right-click on a table to manage indexes and constraints. Create, edit, or drop indexes and constraints as needed.

Interacting with NoSQL Datasources

Explore NoSQL

  1. Explore NoSQL Collections or Tables:

  2. Once connected to a NoSQL datasource, explore collections or tables to view and interact with NoSQL data.

  3. Execute NoSQL Queries:

  4. Perform queries on NoSQL data using the respective query language or tools provided by the NoSQL datasource.

Anonymizing Data

  1. Select Columns for Anonymization:

  2. Right-click on a table and choose "Anonymize Data" to select specific columns for anonymization.

  3. Choose Anonymization Type:

  4. Select the type of anonymization or masking for the chosen columns. Options may include randomization, data scrambling, or setting values to null.

  5. Execute Anonymization:

  6. Execute the anonymization process to apply the chosen anonymization type to the selected columns.

Actions in the Database Explorer

Explorer Actions

1. Refresh Database Connection:

  • Use the "Refresh" button or right-click on a connection to refresh the list of objects and their statuses.

2. Show Contents:

  • Use the "Show Contents" menu to execute a query to select all the records.

3. Generate query scripts:

  • Use the "Select", "Insert", "Update", "Delete" menu items (once the "Columns" node is expanded) to generate the corresponding query in the SQL Console.

4. Import and Export Data:

  • Import and export data to and from tables using the "Import Data" and "Export Data" options.

5. Export Metadata:

  • Export metadadata from schema using the "Export Metadata" option.

Conclusion

The "Database Explorer" in the Databases perspective of the codbex platform provides a comprehensive and user-friendly interface for managing and interacting with databases. Explore its features to streamline database-related tasks and enhance your development workflow.