MSSQL
Microsoft SQL Server Tested for version 2000+
Overview JDBC Drivers Features Supported Objects Download

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 TypeActionsViewers
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 ↗