Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an annotation feature class containing several annotation classes. There are SQL queries set on the annotation classes. They act as a definition query, determining which features are part of a certain annotation class.

An example would be OBJTYP = '3A' OR OBJTYP = '3B' OR OBJTYP = '3C'. The queries originate from the label settings on the layer which was used to create the annotation feature class.

I now want to change the SQL queries. Is there a way to do this?

share|improve this question
What are the SQL Queries doing? Are these definition queries, or were these used to fill the annotation classes to start with? Please provide some more detail, perhaps include what the sql strings are supposed to return. – Get Spatial Jul 6 '12 at 15:40
up vote 1 down vote accepted

You can change these and other properties of the annotation feature class in ArcCatalog. Just double click on the annotation feature class to open the properties and switch to the Annotation Classes tab. Make sure there is no lock on the feature class, otherwise everything is grayed out. My feature class was being used in a map service, therefore it was locked permanently. That's why I got the impression that these properties can't be changed at all.

ESRI Support helped me out on this one.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.