Database information,Reindex Synchronize table database Truncate table in MSD Axapta

Database information,Re index,Synchronize table database, Truncate table in Axapta

To get Database information for your AX Just following following step

1. Click Area Page node: Administration -> Inquiries -> Database -> Database information.

2. Close the Database information form.


Reindex Table

1. Click Area Page node: Administration -> Periodic -> SQL administration.
Select all table

2. Click the Index actions -> Reindex menu button.

To Check/Synchronize Table
1.Click Area Page node: Administration -> Periodic -> SQL administration.
2. Click the Table actions -> Check/Synchronize menu button.

Same way you can use other option Like Synchronize database

1. Click Area Page node: Administration -> Periodic -> SQL administration.
2. Click the Table actions -> Synchronize Database.

Truncate Table-If you want to delete all records of particular table then you can use truncate option.

1. Click Area Page node: Administration -> Periodic -> SQL administration.
2. Click the Table actions ->Truncate

Truncate is dangerous option so please avoid to use this option