Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> About Data Studio> Supported Functions
View PDF

Supported Functions

Data Studio supports online analytical processing (OLAP). OLAP databases refer to GaussDB A and GaussDB(DWS).

The following table describes the functions/operations of Data Studio that are supported by GaussDB A and GaussDB(DWS).

Connection Profiles

Function/Operation

GaussDB A

GaussDB(DWS)

Adding a Connection

Renaming a Connection

Editing a Connection

Removing a Connection

Viewing Connection Properties

Databases

Function/Operation

GaussDB A

GaussDB(DWS)

Creating a Database

Disconnecting All Databases

Connecting to a Database

Disconnecting a Database

Renaming a Database

Dropping a Database

Viewing Properties of a Database

Schemas

Function/Operation

GaussDB A

GaussDB(DWS)

Creating a Schema

Exporting Schema DDL

Exporting Schema DDL and Data

Renaming a Schema

Dropping a Schema

Creating Function/Procedure

Function/Operation

GaussDB A

GaussDB(DWS)

Creating Function/Procedure

Debugging a PL/SQL Function

Dropping a Function/Procedure

Exporting a Function/Procedure DDL

Editing a Function/Procedure

Using Breakpoints

Viewing Callstack

Operating on Variables

Editing a Function/Procedure

Tables (GaussDB A)

Function/Operation

GaussDB A

GaussDB(DWS)

Overview

Creating Foreign Table

Overview

Managing Table and Managing Table Data

Function/Operation

GaussDB A

GaussDB(DWS)

Renaming a Table

Truncating a Table

Reindexing a Table

Analyzing a Table

Vacuuming a Table

Setting the Table Description

Setting the Tablespace

Setting the Schema

Dropping a Table

Viewing Table Properties

Exporting Table DDL

Exporting Table DDL and Data

Exporting Table Data

Showing DDL

Importing Table Data

Viewing Table Data

Editing Table Data

Working with Columns

Function/Operation

GaussDB A

GaussDB(DWS)

Creating a New Column

Renaming a Column

Toggle Not Null

Dropping a Column

Setting the Default Value of a Column

Changing the Data Type

Working with Constraints

Function/Operation

GaussDB A

GaussDB(DWS)

Creating a Constraint

Renaming a Constraint

Dropping a Constraint

Working with Indexes

Function/Operation

GaussDB A

GaussDB(DWS)

Creating a New Index

Renaming an Index

Changing a Tablespace

Changing the Fill Factor

Dropping an Index

Working with Partitions

Function/Operation

GaussDB A

GaussDB(DWS)

Renaming a Partition

Dropping a Partition

Sequences

Function/Operation

GaussDB A

GaussDB(DWS)

Creating Sequence

Dropping a Sequence

Dropping a Sequence Cascade

Views

Function/Operation

GaussDB A

GaussDB(DWS)

Creating a View

Exporting the View DDL

Dropping a View

Dropping a View Cascade

Renaming a View

Setting the Schema for a View

Viewing the DDL

Setting the Default Value for the View Column

Viewing the Properties of a View

Tablespaces

Function/Operation

GaussDB A

GaussDB(DWS)

Renaming a Tablespace

Setting Tablespace Options

Setting Maximum Tablespace Size

Dropping a Tablespace

Viewing the Tablespace DDL

Users/Roles

Function/Operation

GaussDB A

GaussDB(DWS)

Creating a User/Role

Viewing/Editing User/Role Properties

Viewing the User/Role DDL

Search Objects

Function/Operation

GaussDB A

GaussDB(DWS)

Edit

SQL Terminal

Function/Operation

GaussDB A

GaussDB(DWS)

Auto Commit

Selecting a DB Object in the SQL Terminal

Error Locator

Execute SQL Queries

SQL Assistant

Formatting of SQL Queries

SQL History

Viewing the Query Execution Plan and Cost Graphically

Working with the SQL Terminals

Function/Operation

GaussDB A

GaussDB(DWS)

Execute SQL Queries

Execute SQL Queries

Execute SQL Queries

Batch Operation

Function/Operation

GaussDB A

GaussDB(DWS)

Dropping a Batch of Objects

Parent topic: About Data Studio