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
Image Image Databases
 Create Database Catalogs
Image Image Catalog
   References[1], Info, Tables[1]
Image Image Schemas
 Create Schema Schemas
Image Image Schema
 Export Schema[2], Drop Schema References, Tables
Image Image Tables
 Create Table[2], Import Table Data[2] References, Tables
Image Image Table
 Alter Table[2], Create Trigger, Export Table[2], Import Table Data[2], Script: Script Table, Add Extended Property, Create Index, Delete Extended Property, Drop Table, Edit Extended Property, Empty Table, Rename Table Navigator[2], References, Data, Columns, Constraints, DDL[2], Extended Properties, Grants, Indexes, Indexes[3], Info, Primary Key, Row Count, Row Id, Triggers
Image Image History Table[4]
   Extended Properties, Grants, Indexes, Info
Image Image Columns
   Columns, Extended Properties
Image Image Column
 Add Extended Property, Delete Extended Property, Edit Extended Property, Rename Column Column, Extended Properties
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Drop Index, Rebuild Index[5], Rename Index DDL[5][2], Index
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[2], Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[2], Info
Image Image Constraints[3]
   Constraints
Image Image Primary Keys
   Primary Keys
Image Image Primary Key Constraint
   Primary Key
Image Image Primary Key Constraint Column
    
Image Image Foreign Keys
   Foreign Keys
Image Image Foreign Key Constraint
   Foreign Key
Image Image Foreign Key Constraint Column
    
Image Image Unique Constraints
   Unique Constraints
Image Image Unique Constraint
   Unique Constraints
Image Image Unique Constraint Column
    
Image Image Check Constraints
   Check Constraints
Image Image Check Constraint
   Check Constraint
Image Image Check Constraint Column
    
Image Image Default Constraints
   Default Constraints
Image Image Default Constraint
   Info
Image Image Views
   Views
Image Image View
 Export View[2], Script: Script View, Add Extended Property, Create Trigger, Delete Extended Property, Drop View, Edit Extended Property, Rename View Data, Columns, DDL[2], Extended Properties, Indexes, Info, Row Count
Image Image Columns
   Columns, Extended Properties
Image Image Column
 Add Extended Property, Delete Extended Property, Edit Extended Property, Rename Column Column, Extended Properties
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[2], Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[2], Info
Image Image Synonyms
 Create Synonym Synonyms
Image Image Synonym
 Drop Synonym Info
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Drop Index, Rebuild Index[5], Rename Index DDL[5][2], Index
Image Image Sequences[6]
 Create Sequence Sequences
Image Image Sequence
 Drop Sequence Info
Image Image User Defined Data Types
   User Defined Data Types
Image Image Type
 Drop Type User Defined Data Type
Image Image User Defined Table Types
   User Defined Table Types
Image Image Table Type
   User Defined Table Type
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[2], Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor[2], Info
Image Image Stored Procedures
 Create Procedure Procedures
Image Image Procedure
 Export Procedure[2], Script: Script Procedure, Drop Procedure, Rename Procedure Procedure Editor[2], Interface
Image Image Functions
 Create Function Functions
Image Image Function
 Export Function[2], Script: Script Function, Drop Function, Rename Function Function Editor[2], Interface
Image Image Users[6]
   Users
Image Image User
 Alter User[7], Change User Password, Drop User User
Image Image Users
   Users
Image Image Database Roles
   Roles
Image Image Role
   Info, Users[7]
Image Image Linked Servers[8]
 Create Linked Server Linked Servers
Image Image Linked Server
 Add Login, Drop Linked Server, Drop Linked Server Login, Enable/Disable Options, Set Remote Collation, Set Timeout Options, Test Connection Info
Image Image Databases
   Catalogs
Image Image Linked Server Catalog
    
Image Image Schemas
   Schemas
Image Image Linked Server Schema
    
Image Image Tables
   Tables
Image Image Linked Server Table
   Data, Columns, Foreign Keys, Grants, Info, Primary Key, Row Count
Image Image Columns
   Columns
Image Image Linked Server Column
   Column
Image Image Views
   Views
Image Image Linked Server View
   Data, Columns, Info, Row Count
Image Image Columns
   Columns
Image Image Linked Server Column
   Column
Image Image Synonyms
   Synonyms
Image Image Linked Server Synonym
   Column
Image Image DBA Views
   DBA
Image Image Server Info
   Latest Error Log[7], Server Info
Image Image Logins[6]
   Logins
Image Image Login
   Login, Users
Image Image Logins
   Logins
Image Image Database Devices[7]
   Database Devices
Image Image Processes[7]
   Processes
Image Image Process
 Kill Process Process
Image Image Processes
   Processes
Image Image Process
 Kill Process Process
Image Image Server Roles[7]
   Roles
Image Image Server Role
   Info, Users
Image Image SQL Server Agent[9]
   Latest Error Log, Sql Server Agent
Image Image Agent Jobs
 Create Job Jobs
Image Image Job
 Create Step, Delete Job, Edit, Edit Notifications, Enable/Disable Job, Start the job Alerts, History, Steps, info
Image Image Job Step
 Copy Step, Delete Job Step, Edit Step info
Image Image Schedules
 Attach Schedule Schedules
Image Image Job Schedule
 Detach Schedule, Enable/Disable Schedule Schedules
Image Image Targets
 Add Server Servers
Image Image Job Server
 Delete Server Server
Image Image Schedules
 Add Recurring Daily, Add Recurring Monthly, Add Recurring Weekly, Add one time, Add other Schedules
Image Image Scheduler Schedule
 Delete Schedule, Enable/Disable Schedule Jobs, Schedules
Image Image Alerts
   Alerts
Image Image Alert
   Alert, Operators
Image Image Operators
   Operators
Image Image Operator
   Alerts, Info, Jobs
Image Image Locks[7]
   Locks
[1] drop-on-condition:true
[2] DbVisualizer Pro
[3] Version 10 and later
[4] Version 13 and later
[5] Version 9 and later
[6] Version 11 and later
[7] Not Azure SQL Database
[8] Version 10 and when linked servers is supported
[9] Version 9 and not Azure SQL Database