Overview

Table Data Manager was built to enable the management of tables and views in an Azure SQL Database. A design environment facilitates the defining of tables and views. The separation between the design environment and database implementation provides flexibility. Table and view definitions can be copied between databases, along with data records between tables. Active transactions can be reviewed to uncover possible locking/blocking issues between each database environment.

Table Data Manager provides the following:

• Access to application or external database architecture.

• Ability to manipulate tables and views inside of a database.

• A solution for consultants to interact with the database for the delivery of customer-driven solutions.

Access to Table Data Manager is limited to those with the System Administrator security role. This should be strictly enforced because of accessibility to application information and controls.