The SQL Assistant menu bar provides commands to edit and run the SQL scripts. Most of the commands are standard SQL commands. The following table shows some useful commands.
Menu | Description |
---|---|
File |
Commands to store and reuse the SQL expressions. The default folder for (*.sql) files is
C:\Users\<username>\AppData\Local\Autodesk\Autodesk AutoCAD Map 3D <release>\Rxx.x\<language>\Data\SQLSheet\Scripts.
|
Edit | Commands to edit the content of the Expression input box and the Executed Script output box. |
Execute |
Commands to execute and commit the select statements.
|
Scripts | Starts SQL scripts stored in (*.sql) files. The menu shows all (*.sql) files stored under
C:\Users\<username>\AppData\Local\Autodesk\Autodesk AutoCAD Map 3D <release>\Rxx.x\<language>\Data\SQLSheet\Scripts. Scripts in a subfolder appear in a submenu.
Copy your own SQL scripts to this location to make them available through this menu. |
Tools |
Commands to start tools.
|