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 Type Actions Viewers
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
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 ↗