Administration> Periodic> SQL administration

Use this form to view SQL Server tables and indexes, and to synchronize tables and indexes with changes that have been made in the Application Object Tree (AOT).

Navigating the form

You can expand the list of tables and indexes in the tree control on the left side of the form.

The following table provides descriptions for the controls in this form.

Buttons

Button	Description
Table actions	Opens a menu that includes the following items: Synchronize databaseSynchronizes the schema (table and index information) from the AOT to the database. Synchronization generates the Microsoft Dynamics AX index ( Axapd.aoi). Check/SynchronizeChecks that the schema in the AOT matches the schema in the database, and synchronizes any parts that do not match. Synchronization generates the Microsoft Dynamics AX index ( Axapd.aoi). Browse tableOpens the Table browserform so that you can view the fields and rows in the table. TruncateDeletes all content in the table for all company accounts. Use this command with caution.
Index actions	Opens a menu that includes the following item: ReindexRegenerates the selected index.
Generate SQL scripts	Opens a menu that includes the following items: .... for dropping tablesGenerates a script that you can use to drop the selected tables from the database. .... for creating tablesGenerates a script that you can use to add the selected tables to the database.

Button

Description

Table actions

Opens a menu that includes the following items:

Synchronize databaseSynchronizes the schema (table and index information) from the AOT to the database. Synchronization generates the Microsoft Dynamics AX index ( Axapd.aoi).
Check/SynchronizeChecks that the schema in the AOT matches the schema in the database, and synchronizes any parts that do not match. Synchronization generates the Microsoft Dynamics AX index ( Axapd.aoi).
Browse tableOpens the Table browserform so that you can view the fields and rows in the table.
TruncateDeletes all content in the table for all company accounts. Use this command with caution.

Index actions

Opens a menu that includes the following item:

ReindexRegenerates the selected index.

Generate SQL scripts

Opens a menu that includes the following items:

.... for dropping tablesGenerates a script that you can use to drop the selected tables from the database.
.... for creating tablesGenerates a script that you can use to add the selected tables to the database.

English-to-Russian translation