SQL Assistant Menu Bar

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.

Note: Some commands and icons are deactivated in the SQL Assistant. They are available if you use the SQL Sheet.

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. Open—Opens an existing (*.sql) file and adds it to the Expression input box. You can edit the expression, and then execute it. Save—Saves the content of the expression input box. Save Output As—Saves the content of the Executed Script output box.
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. Execute At Cursor—Executes the select statement beginning at the cursor position. Use this command to execute part of a large SQL expression. Spool—Creates a spool file, by default, named C:\Users\<username>\AppData\Local\Autodesk\Autodesk AutoCAD Map 3D <release>\Rxx.x\<language>\Data\SQLSheet\Log\Spool.log. History—Displays all select statements that were executed. To re-use, select the select statement, and click Copy To SQL Sheet.
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. Gather Table Statistics—Update the record numbers that are displayed with the table names in the table list. Spool File—Opens the spool file. Log File—Opens the log file. Options—Auto-commit setting and import/export command parameters. For example, set EnableF4 to False to prevent the content of the input or output box being removed when you press [F4]. Set Show Amount Of Records Behind The Table to True to display the number of records in USER_TABLES.NUM_ROWS.