sap
SAP ASE Tested for version 12.5+
Overview JDBC Drivers Features Supported Objects Download

SAP ASE

SAP ASE object type support.

The following table shows the database specific support in DbVisualizer for SAP ASE organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
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
SystemTables
   SystemTables
SystemTable
 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
ViewTriggers
   Triggers
ViewTrigger
 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
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
Types
   User Defined Data Types
DBA
   DBA
ServerInfo
   Character Set, Server Info
Logins
 Create Login Logins
Login
 Change Password, Drop Login Databases, Info, Roles
Devices
 Create Device Database Devices
Device
 Drop Device Databases, Info
RemoteServers
   Remote Servers
Processes
   Processes
ServerRoles
   Roles
ServerRole
   Info, Logins
Transactions
   Transactions
Locks
   Blocked or Waiting Objects[2], Locks
[1] DbVisualizer Pro
[2] Version 16 and later
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗