Removing definition query in ArcPy?

Question

I have created one script which set a defination query at certain location in script. I use lyr.definitionquery = "some expression"

After running the script i want to remove the definition query . But not getting any hint to do it.

• FelixIP: It is the same lr.definitionQuery=""
• PolyGeo: I think definitionquery should be definitionQuery

Answer 1

Just clear that property:

lyr.definitionQuery = None

None is the python for NULL, so making it = None will clear the query.

• PolyGeo: I always do it using ""
• Midavalo: Yes you can also do it using "" but I don't think it matters. I've developed a habit of using Nulls over empty strings, but either works.

Answer 2

I use an empty string to clear a definition query from a layer:

lyr.definitionQuery = ""