Working with Altibase Explorer
Altibase Explorer is both the main entry point for connecting to databases and a meta browser for navigating and manipulating database objects.
The main features of Altibase Explorer are as follows:
- Provide a view to register, unregister, and edit database connections and platforms.
- Show the meta information of connected databases in a tree structure for ease of navigation.
- Provide a convenient way to create, edit, and drop database objects and change their privileges.
The basic steps for administrating database connections and platforms have already
been explained in "Getting Started".
This chapter will completely elucidate the database objects in Altibase Explorer.
The following database objects and operations are supported in AdminCenter for Developers version 1.0.0 and explained one by one below.
Schema Objects
Table
Queue
Index
View
Sequence
Synonym
Function
Procedure
Typeset
Trigger
Non-Schema Objects
Public Synonym
Performance View
User
Directory
Tablespace
Schema Objects
- Create: Create an object.
- Drop: Remove the selected object(s).
- Count rows: Count the rows in the selected table(s).
- Truncate: Count the rows in the selected table(s).
- Rename: Change the name of the selected table.
- Compact: Return unused memory to Altibase DBMS. (Only works for memory tables, and only in versions 4.3.9.166 and above.)
- Object Privileges: Grant/revoke object privileges to/from other users.
- Detail: Show the details of the target database object.
- Import: Import data in a CSV or Excel file into the target database object.
- Export: Export data on the target database object into user specified CSV or Excel file.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Compact: Return unused memory to Altibase DBMS. (Supported in versions 5.1.5 and above.)
- Detail: Show the details of the target database object.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Rename: Change name of an index (Supported in versions 5.3.1 and above.)
- Detail: Show the details of the target database object.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Compile: Recompile the selected view.
- Object Privileges: Grant/revoke object privilege to/from other users.
- Detail: Show the details of the target database object.
- Export: Export data on the target database object into user specified CSV or Excel file.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Edit: Change the properties of the selected sequence.
- Object Privileges: Grant/revoke object privilege to/from other users.
- Detail: Show the details of the target database object.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Detail: Show the details of the target database object.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Compile: Recompile the selected function.
- Object Privileges: Grant/revoke object privilege to/from other users.
- Detail: Show the details of the target database object.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Compile: Rebuild the plan of the selected procedure.
- Object Privileges: Grant/revoke object privilege to/from other users.
- Detail: Show the details of the target database object.
Back to list
- Drop: Remove the selected object(s).
- Detail: Show the details of the target database object.
Back to list
- Create: Create an object.
- Drop: Remove the selected object(s).
- Compile
- Enable/Disable: Change state of the selected trigger.
- Object Privileges: Grant/revoke object privilege to/from other users.
- Detail: Show the details of the target database object.
Back to list
Non-Schema Objects
- Create: Create an object.
- Drop: Remove the selected object(s).
- Detail: Show the details of the target database object.
Back to list
- Detail: Show the details of the target database object.
Back to list
- Detail: Show the details of the target database object.
Back to list
- Detail: Show the details of the target database object.
Back to list
- Create: Create an object.
- Drop: Remove the selected user.
- Change Password: Alter the password of the selected user.
- Access control: Alter the privileges for tablespace access.
- Default Tablespace: Alter the user's default tablespaces (data and temp).
- System Privileges: Grant/revoke system privileges to/from the selected user.
- Detail: Show the user details.
Back to list