Database information,Re index,Synchronize table database, Truncate table in Axapta
To get Database information for your AX Just following following step1. 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