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
Catalogs
   Catalogs
SystemCatalogs
    
SystemCatalog
    
Schemas
 Create Schema Schemas
Schema
 Export Schema[1], Drop Schema References, Tables
SystemTables
   References, System Tables
SystemTable
   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
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
SystemUsers
   Users
SystemUser
   User
Roles
   Roles
Role
   Info
Catalog
   References, Tables
Schemas
 Create Schema Schemas
Schema
 Export Schema[1], Drop Schema References, Tables
ExternalTables
 Create External Table References, External Tables
ExternalTable
 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
PrimaryKeyConstraints
   Primary Keys
PrimaryKeyConstraint
   Primary Key
PrimaryKeyConstraintColumn
    
UniqueConstraints
   Unique Constraints
UniqueConstraint
   Unique Constraints
UniqueConstraintColumn
    
DefaultConstraints
   Default Constraints
DefaultConstraint
   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
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
Roles
   Roles
Role
   Info
ExternalResources
    
ExternalDataSources
 Create External Data Source External Data Sources
ExternalDataSource
 Drop External Data Source External Data Source
ExternalFileFormats
 Create External File Format Delimited Text, Create External File Format Parquet External Data Sources
ExternalFileFormat
 Drop External File Format External Data Source
DatabaseScopedCredentials
 New Database Scoped Credential Database Scoped Credentials
DatabaseScopedCredential
 Drop Database Scoped Credential Database Scoped Credential
DBA
   DBA
ServerInfo
   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