MSSQL
Microsoft SQL Server Tested for version 2000+

Microsoft SQL Server

Microsoft SQL Server object type support.

The following table shows the database specific support in DbVisualizer 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
  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], Script: Script Table, Add Extended Property, Create Index, Delete Extended Property, Drop Table, Edit Extended Property, Empty Table, Rename Table Navigator[1], References, Data, Columns, Constraints, 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
Script: Script 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
Constraints[2]
  Constraints
PrimaryKeyConstraints
  Primary Keys
PrimaryKeyConstraint
  Primary Key
PrimaryKeyConstraintColumn
   
ForeignKeyConstraints
  Foreign Keys
ForeignKeyConstraint
  Foreign Key
ForeignKeyConstraintColumn
   
UniqueConstraints
  Unique Constraints
UniqueConstraint
  Unique Constraints
UniqueConstraintColumn
   
CheckConstraints
  Check Constraints
CheckConstraint
  Check Constraint
CheckConstraintColumn
   
DefaultConstraints
  Default Constraints
DefaultConstraint
  Info
Views
  Views
View
Export View[1], Script: Script View, Add Extended Property, Create Trigger, Delete Extended Property, Drop View, Edit Extended Property, Rename 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
Script: Script 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], 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[5]
  Users
User
Alter User[6], Change User Password, Drop User User
Users
  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[5]
  Logins
Login
  Login, Users
Logins
  Logins
Devices[6]
  Database Devices
Processes[6]
  Processes
Process
Kill Process Process
Processes
  Processes
Process
Kill Process Process
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
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 ↗