Azure Synapse.
Azure Synapse Dedicated
Overview Features Supported Objects Download

Azure Synapse Dedicated

Azure Synapse Dedicated object type support.

The following table shows the database specific support in DbVisualizer for Azure Synapse Dedicated 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
Databases
   Catalogs
System Databases
    
System Catalog
    
Schemas
 Create Schema Schemas
Schema
 Export Schema[1], Drop Schema References, Tables
System Tables
   References, System Tables
System Table
   Data, Columns, DDL[1], Info, Row Id
Columns
   Columns
Column
 Rename Column Column
Views
   Views
View
 Export View[1], Script: Script View, Drop View Data, Columns, DDL[1], Indexes, Info, Row Count
Columns
   Columns
Column
 Rename Column Column
Stored Procedures
 Create Procedure Procedures
Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1], Interface
Functions
 Create Function Functions
Function
 Export Function[1], Script: Script Function, Drop Function Function Editor[1], Interface
Users
   Users
System User
   User
Database Roles
   Roles
Role
   Info
Catalog
   References, Tables
Schemas
 Create Schema Schemas
Schema
 Export Schema[1], Drop Schema References, Tables
External Tables
 Create External Table References, External Tables
External Table
 Script: Script External Table, Drop External Table Data, Columns, DDL[1], Info, Row Id
Columns
   Columns
Column
 Rename Column Column
Tables
 Create Table[1], Import Table Data[1] References, Tables
Table
 Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Create Index, Drop Table, Empty Table Navigator[1], References, Data, Columns, Constraints, DDL[1], Grants, Indexes, Info, Primary Key, Row Count, Row Id
Columns
   Columns
Column
 Rename Column Column
Indexes
   Indexes
Index
 Script: Script Index, Drop Index, Rebuild Index DDL[1], Index
Constraints
   Constraints
Primary Keys
   Primary Keys
Primary Key Constraint
   Primary Key
Primary Key Constraint Column
    
Unique Constraints
   Unique Constraints
Unique Constraint
   Unique Constraints
Unique Constraint Column
    
Default Constraints
   Default Constraints
Default Constraint
   Info
Views
   Views
View
 Export View[1], Script: Script View, Drop View Data, Columns, DDL[1], Indexes, Info, Row Count
Columns
   Columns
Column
 Rename Column Column
Indexes
   Indexes
Index
 Script: Script Index, Drop Index, Rebuild Index DDL[1], Index
Stored Procedures
 Create Procedure Procedures
Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1], Interface
Functions
 Create Function Functions
Function
 Export Function[1], Script: Script Function, Drop Function Function Editor[1], Interface
Users
 SQL User With Login, SQL User Without Login Users
User
 Drop User User
Database Roles
   Roles
Role
   Info
External Resources
    
External Data Sources
 Create External Data Source External Data Sources
External Data Source
 Drop External Data Source External Data Source
External File Formats
 Create External File Format Delimited Text, Create External File Format Parquet External Data Sources
External File Format
 Drop External File Format External Data Source
Database Scoped Credentials
 New Database Scoped Credential Database Scoped Credentials
Database Scoped Credential
 Drop Database Scoped Credential Database Scoped Credential
DBA Views
   DBA
Server Info
   Server Info
Logins
 Create New Login Logins
Login
 Alter Login, Change Login Password, Drop Login, Enable/Disable Login Login
Processes
   Processes
Process
 Kill Process Process
[1] DbVisualizer Pro