SAP ASE
The following table shows the database specific support in DbVisualizer for SAP ASE organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
Databases | ||
Catalog | References, Tables | |
Schemas | Schemas | |
Schema | Export Schema[1] | References, Tables |
Tables | Create Table[1], Import Table Data[1] | References, Tables |
Table | Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Create Index, Drop Table, Empty Table, Rename Table | Navigator[1], References, Data, Columns, DDL[1], Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers |
Columns | Columns | |
Column | Rename Column | Column |
Indexes | Indexes | |
Index | Drop Index, Rename Index | Columns, Index |
Triggers | Triggers | |
Trigger | Export Trigger[1], Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger | Trigger Editor[1], Info |
System Tables | SystemTables | |
System Table | Script: Script System Table | Data, Columns, Info, Row Count |
Views | Views | |
View | Create Trigger, Export View[1], Script: Script View, Drop View, Rename View | Data, Columns, DDL[1], Grants, Indexes, Info, Row Count, Triggers |
Columns | Columns | |
Column | Rename Column | Column |
Triggers | Triggers | |
View Trigger | Export Trigger[1], Drop Trigger, Rename Trigger | Trigger Editor[1], Info |
Indexes | Indexes | |
Index | Drop Index, Rename Index | Columns, Index |
Triggers | Triggers | |
Trigger | Export Trigger[1], Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger | Trigger Editor[1], Info |
Stored Procedures | Create Procedure | Procedures |
Procedure | Export Procedure[1], Script: Script Procedure, Drop Procedure, Rename Procedure | Procedure Editor[1], Interface |
Functions | Create Function | Functions |
Function | Export Function[1], Script: Script Function, Drop Function, Rename Function | Function Editor[1], Interface |
Users | Add User | Users |
User | Drop User | Info |
Groups | Add Group | Groups |
Group | Drop Group | Info, Users |
User Defined Data Types | User Defined Data Types | |
DBA Views | DBA | |
Server Info | Character Set, Server Info | |
Logins | Create Login | Logins |
Login | Change Password, Drop Login | Databases, Info, Roles |
Database Devices | Create Device | Database Devices |
Device | Drop Device | Databases, Info |
Remote Servers | Remote Servers | |
Processes | Processes | |
Roles | Roles | |
Server Role | Info, Logins | |
Transactions | Transactions | |
Locks | Blocked or Waiting Objects[2], Locks | |
|
[1]
DbVisualizer Pro
[2] Version 16 and later | ||