| Object Type |
Actions |
Viewers |
|
|
Catalogs
|
|
Create Database
|
Catalogs
|
|
|
|
Catalog
|
|
|
References, Tables
|
|
|
|
Schemas
|
|
Create Schema
|
Schemas
|
|
|
|
Schema
|
|
Export Schema[1], Drop Schema
|
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], Add Extended Property, Create Index, Delete Extended Property, Drop Table, Edit Extended Property, Empty Table, Rename Table, Script: Script Table
|
Navigator[1], References, Data, Columns, DDL[1], Extended Properties, Grants, Indexes, Indexes[2], Info, Primary Key, Row Count, Row Id, Triggers
|
|
|
|
HistoryTable[3]
|
|
|
Extended Properties, Grants, Indexes, Info
|
|
|
|
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 Index[4], Rename Index
|
DDL[4][1], Index
|
|
|
|
Triggers
|
|
|
Triggers
|
|
|
|
Trigger
|
|
Export Trigger[1], Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger
|
Trigger Editor[1], Info
|
|
|
|
Views
|
|
|
Views
|
|
|
|
View
|
|
Export View[1], Add Extended Property, Create Trigger, Delete Extended Property, Drop View, Edit Extended Property, Rename View, Script: Script View
|
Data, Columns, DDL[1], 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[1], Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger
|
Trigger Editor[1], Info
|
|
|
|
Synonyms
|
|
Create Synonym
|
Synonyms
|
|
|
|
Synonym
|
|
Drop Synonym
|
Info
|
|
|
|
Indexes
|
|
|
Indexes
|
|
|
|
Index
|
|
Drop Index, Rebuild Index[4], Rename Index
|
DDL[4][1], Index
|
|
|
|
Sequences[5]
|
|
Create Sequence
|
Sequences
|
|
|
|
Sequence
|
|
Drop Sequence
|
Info
|
|
|
|
Types
|
|
|
User Defined Data Types
|
|
|
|
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], Drop Procedure, Rename Procedure, Script: Script Procedure
|
Procedure Editor[1], Interface
|
|
|
|
Functions
|
|
Create Function
|
Functions
|
|
|
|
Function
|
|
Export Function[1], Drop Function, Rename Function, Script: Script Function
|
Function Editor[1], Interface
|
|
|
|
Users[6]
|
|
|
Users
|
|
|
|
Roles
|
|
|
Roles
|
|
|
|
Role
|
|
|
Info, Users[6]
|
|
|
|
LinkedServers[7]
|
|
Create Linked Server
|
Linked Servers
|
|
|
|
LinkedServer
|
|
Add Login, Drop Linked Server, Drop Linked Server Login, Enable/Disable Options, Set Remote Collation, Set Timeout Options, Test Connection
|
Info
|
|
|
|
LinkedServerCatalogs
|
|
|
Catalogs
|
|
|
|
LinkedServerCatalog
|
|
|
|
|
|
|
LinkedServerSchemas
|
|
|
Schemas
|
|
|
|
LinkedServerSchema
|
|
|
|
|
|
|
LinkedServerTables
|
|
|
Tables
|
|
|
|
LinkedServerTable
|
|
|
Data, Columns, Foreign Keys, Grants, Info, Primary Key, Row Count
|
|
|
|
LinkedServerColumns
|
|
|
Columns
|
|
|
|
LinkedServerColumn
|
|
|
Column
|
|
|
|
LinkedServerViews
|
|
|
Views
|
|
|
|
LinkedServerView
|
|
|
Data, Columns, Info, Row Count
|
|
|
|
LinkedServerColumns
|
|
|
Columns
|
|
|
|
LinkedServerColumn
|
|
|
Column
|
|
|
|
LinkedServerSynonyms
|
|
|
Synonyms
|
|
|
|
LinkedServerSynonym
|
|
|
Column
|
|
|
|
DBA
|
|
|
DBA
|
|
|
|
ServerInfo
|
|
|
Latest Error Log[6], Server Info
|
|
|
|
Logins[6]
|
|
|
Logins
|
|
|
|
Devices[6]
|
|
|
Database Devices
|
|
|
|
Processes[6]
|
|
|
Processes
|
|
|
|
ServerRoles[6]
|
|
|
Roles
|
|
|
|
ServerRole
|
|
|
Info, Users
|
|
|
|
ServerAgent[8]
|
|
|
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[6]
|
|
|
Locks
|
[1]
DbVisualizer Pro
[2]
Version 10 and later
[3]
Version 13 and later
[4]
Version 9 and later
[5]
Version 11 and later
[6]
Not Azure SQL Database
[7]
Version 10 and when linked servers is supported
[8]
Version 9 and not Azure SQL Database
|
