Effective security management
Creating and editing database users and roles
Creating and editing database users and roles
Effective security management
- Creating and editing database users and roles
- Grant Manager displaying all database object grants in the form of a grid
- Setting object permissions to database users and roles in object editors
- Powerful login manager for administering server logins
- Managing server roles
- Creating and editing custom server roles
Powerful visual database designer
Efficient reports management
- Create Report Wizard allows you to create simple reports in a few clicks
- Managing reports in the same way as if they were database objects
- Report Designer with clear in use report construction tools
- HTML Report wizard to create a detailed HTML report of your database quickly
Powerful and easy-to-use graphical user interface
Rapid database management and navigation
- Multiple database connections
- Multiple user-defined tabs for any tree node to access it in one-click
- Projects to work with the selected database objects only
- Working with multiple selected objects at a time
- Exploring databases and their objects
- Specifying database properties
- Specifying server properties
Easy management of all SQL Server objects
- Creating and dropping databases and schemas
- Creating new database objects
- Duplicating database objects
- Browsing dependencies between database objects
- Managing tables and all their subobjects
- Editing indexes
- Editing table checks
- Editing foreign keys
- Managing views and all their subobjects
- Creating and editing stored procedures
- Creating and editing user-defined functions
- Creating and editing aggregates
- Creating and editing user-defined types
- Creating and editing DDL triggers
- Creating and editing XML schema collections
- Managing full-text catalogs and full-text indexes
- Managing partition schemes and partition functions
- Managing symmetric and asymmetric keys
- Managing jobs and job steps
- Creating and editing alerts
- Creating and editing operators
- Creating and editing schedules
- Creating and editing proxies
- Creating and editing endpoints
- Creating and editing sequences
Advanced data manipulation tools
- Viewing table data as a grid
- Multi-level master-detail view to work with several linked tables at the same time
- Plenty of useful tools such as data grouping fast search and filtering
- Powerful BLOB viewer with several types of viewing BLOB data
- Table and card views to see data the way you like
Excellent visual and text tools for query building
- Ability to view actual and estimated query plan as a diagram
- Multiple SQL editors with code completion and syntax highlight
- Managing Favorite queries
- Query builder allowing you to build complicated queries visually




