Database specific support for Microsoft SQL ServerDatabase specific support for Microsoft SQL Server

The following table show the database specific support for Database specific support for Microsoft SQL Server 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 Type Actions Viewers
Catalogs
Create Database Catalogs
Catalog
Drop Database, Rename Database  
Schemas
Create Schema Schemas
Schema
Export Schema, Drop Schema  
Tables
Create Table, Import Table Data References, Tables
Table
Alter Table, Create Trigger, Export Table, Import Table Data, Add Extended Property, Create Index, Delete Extended Property, Drop Table, Edit Extended Property, Empty Table, Rename Table, Script: Script Table Navigator1, References, Columns, DDL, Data, Extended Properties, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Columns
  Columns, Extended Properties
Column
Add Extended Property, Delete Extended Property, Edit Extended Property, Rename Column Column, Extended Properties
Indexes
  Indexes
Index
Drop Index, Rebuild Index2, Rename Index DDL2, Index
Triggers
  Triggers
Trigger
Export Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Views
  Views
View
Export View, Add Extended Property, Create Trigger, Delete Extended Property, Drop View, Edit Extended Property, Rename View, Script: Script View Columns, DDL, Data, Extended Properties, Indexes, Info, Row Count
Columns
  Columns, Extended Properties
Column
Add Extended Property, Delete Extended Property, Edit Extended Property, Rename Column Column, Extended Properties
Triggers
  Triggers
Trigger
Export Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Synonyms
Create Synonym Synonyms
Synonym
Drop Synonym Info
Indexes
  Indexes
Index
Drop Index, Rebuild Index2, Rename Index DDL2, Index
Sequences3
Create Sequence Sequences
Sequence
Drop Sequence Info
Types
  User Defined Data Types
Triggers
  Triggers
Trigger
Export Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Procedures
Create Procedure Procedures
Procedure
Export Procedure, Drop Procedure, Rename Procedure, Script: Script Procedure Procedure Editor, Interface
Functions
Create Function Functions
Function
Export Function, Drop Function, Rename Function, Script: Script Function Function Editor, Interface
Users
  Users
Roles
  Roles
Role
  Info, Users
DBA
  DBA
ServerInfo
  Latest Error Log, Server Info
Logins
  Logins
Devices
  Database Devices
RemoteServers
  Remote Servers
Processes
  Processes
ServerRoles
  Roles
ServerRole
  Info, Users
ServerAgent2
  Latest Error Log, Sql Server Agent
Jobs
Create Job Jobs
Job
Create Step, Delete Job, Edit, Edit Notifications, Enable/Disable Job, Start the job Alerts, History, Steps, info
JobStep
Copy Step, Delete Job Step, Edit Step info
JobSchedules
Attach Schedule Schedules
JobSchedule
Detach Schedule, Enable/Disable Schedule Schedules
JobServers
Add Server Servers
JobServer
Delete Server Server
SchedulerSchedules
Add Recurring Daily, Add Recurring Monthly, Add Recurring Weekly, Add one time, Add other Schedules
SchedulerSchedule
Delete Schedule, Enable/Disable Schedule Jobs, Schedules
Alerts
  Alerts
Alert
  Alert, Operators
Operators
  Operators
Operator
  Alerts, Info, Jobs
Locks
  Locks
1) DbVisualizer Pro
2) Version 9 and later
3) Version 11 and later