Type SQL Condition dialog box
 
 
 
NoteThis functionality applies only to drawing objects.

Use this dialog box to create or modify a SQL condition, if you are familiar with SQL.

To retrieve drawing objects based on linked SQL data

Click Home tabData panelDefine Query. At the Command prompt, enter adequery.

History

To modify a condition you used previously, select it from the list. The condition is copied to the Enter SQL Condition area, where you can modify it.

Link Template

Select the link template that specifies the table to use with this condition. The SQL condition tests information linked from this table to the queried objects. Because queries apply only to objects in active source drawing, this list displays only link templates in your source drawings.

Enter SQL Condition

To create a new condition, enter it in the box.

SQL Condition Syntax

SQL has a strict grammatical structure and syntax. Here are some rules to follow when you define SQL statements.

AutoCAD Map 3D supports standard SQL syntax as formally defined in the ANSI X3.135-1989 SQL standard.