Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Batch Operation> Overview
View PDF

Overview

You can view database objects to which you have access in Object Browser in the tree format. For example, you can view the schema names within the selected database and the corresponding table names within the selected schema.

The Object Browser displays only the objects that satisfy the following minimum privilege type requirement for the current user.

Object Type

Privilege to Display in Object Browser

Database

Connect

Schema

Usage

Table

Select

Column

Select

Sequences

Usage

Function/Procedure

Execute

Tablespace

Create

It is not necessary that child objects of a parent object to which you have access will be displayed in Object Browser. For example, if you have access to a table but not have access to one of the columns in that table, then Object Browser displays only the table with columns to which you have access. The columns which you do not have access are not displayed. If access to an object is revoked when an operation is being performed, then an error message is displayed stating that you do not have access to perform the operation, and the object is removed from Object Browser after refresh.

Following database objects are supported (displayed in the tree format):

  • Schemas
  • Functions/Procedures
  • Tables
  • Sequences
  • Views
  • Columns, Constraints, and Indexes
  • Tablespaces

All default created schemas except for public are grouped under Catalogs and user schemas are grouped under Schemas below the respective database.

The Object Browser filter option opens a new tab, where you can enter search scope. After providing text, press Enter to start search. For usability improvement, a search bar is provided on the object browser component and on entering the object name of interest, the tree (if expanded) shall display only the objects that match the filter criteria.

For the nodes that are not expanded the filter rules will be applied when the node is expanded.

Parent topic: Batch Operation