Azure Synapse Dedicated
The following table shows the database specific support in DbVisualizer for Azure Synapse Dedicated organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
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
| ||