SQL Server / Azure

The Database Explorer window provides the following support for SQL Server objects.

Tables

Display

Actions

List Displays

List of objects (Tables, View, Synonyms)
List of objects with Description
List of objects with Date Created / Altered
List of Tables with Table Sizing
List of objects with Object-Id

Details Display

Columns
Column Descriptions
Column Defaults
Columns Rules / Domains
Identity column info
Primary Key columns
Indexes
Check Constraints
Unique Constrains
Authorities on Table
Objects Referencing Table
Triggers on Table
Referenced Tables (foreign keys)
Dependent Tables

Create / Alter / Drop / Redefine Table
Create View on table
Create Primary Key / Index on Table
Create Foreign Key on Table
Create Trigger on Table
Create Check Constraint on Table
Generate DDL for Table and related indexes, keys, views, triggers, constraints
Compare Tables definitions
Manage Table Descriptions
Manage Column Descriptions
Rename table/s
Rename columns
Update Statistics for Table/s
Truncate Table/s
Change Table Schema
Enable/Disable all Triggers on Table
Administer Authorities for Table

Views

Display	Actions
Columns View Definition Indexes Authorities on View Objects Referenced by View Objects Referencing View	Create / Alter / Drop View Create Index on View Generate DDL for View Compare View definitions Manage View Descriptions Rename view/s Change View Schema Administer Authorities for View

Synonyms

Display	Actions
Columns Base Object Authorities on Synonym Objects Referenced by Synonym Objects Referencing Synonym	Manage Synonym Descriptions

Indexes

Display	Actions
Index Details Index Columns	Create / Alter / Drop Index Generate DDL for Index

Triggers

Display	Actions
Trigger Text Trigger Event detail Objects Referenced by Trigger	Create / Alter / Drop Trigger Generate DDL for Trigger Compare Trigger definitions Rename trigger/s Enable / disable trigger/s

Routines (Functions and Triggers)

Display	Actions
Routine Text Routine Parameters Routine Detail Authorities on Routine Objects Referenced by Routine Objects Referencing Routine	Create / Alter / Drop Routine Generate DDL for Routine Compare Routine definitions Rename routine/s Change procedure schema Manage Authorities on routine

Rules / Domains

Display	Actions
Rule Text Details of Rule Columns using Rule

Defaults

Display	Actions
Default Text Details of Default Columns using Default	Create / Drop Default Generate DDL for Default

Users

Display

Actions

List Displays

List of Database Users
List of Database Users with Login
List of Server Users

Details Display

Details of User
Table Authorities for User
Procedure Authorities for User
Function Authorities for User
Roles for User
Login for User

Create / Alter / Drop User
Generate DDL for User
Manage Table Authorities
Manage Procedure Authorities
Manage Function Authorities
Manage Roles for User

Roles

Display

Actions

List Displays

List of Database Roles
List of Server Roles

Details Display

Details of Role
Table Authorities for Role
Procedure Authorities for Role
Function Authorities for Role
Members of Role

Create / Drop Role
Create Application Role
Create Server Role
Generate DDL for User
Manage Table Authorities
Manage Procedure Authorities
Manage Function Authorities
Manage Roles for Role
Manage members of Role

Logins

Display

Actions

List Displays

List of Database Logins
List of Database Logins with Status
List of All Logins

Details Display

Details of Login
User for Login

Create Window Authenticated Login
Create SQL Server Login
Alter / Drop Login
Generate DDL for Login
Grant Login access to this Database
Change Login password

User Types

Display	Actions
Details of Type Columns using Type	Create / Drop Type Generate DDL for Login Compare Type