topic Change Query Layer Definition with Arcpy in Python Questions https://community.esri.com/t5/python-questions/change-query-layer-definition-with-arcpy/m-p/460741#M36094 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have a mxd file with some query layers (File-&gt;Add Data-&gt;Add Query Layers). Is it possible to change the query layers's definition with arcpy? I need change both the SQL statement and the database connection.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Thu, 12 Jul 2012 14:53:36 GMT DanaReed 2012-07-12T14:53:36Z Change Query Layer Definition with Arcpy https://community.esri.com/t5/python-questions/change-query-layer-definition-with-arcpy/m-p/460741#M36094 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have a mxd file with some query layers (File-&gt;Add Data-&gt;Add Query Layers). Is it possible to change the query layers's definition with arcpy? I need change both the SQL statement and the database connection.</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Thu, 12 Jul 2012 14:53:36 GMT https://community.esri.com/t5/python-questions/change-query-layer-definition-with-arcpy/m-p/460741#M36094 DanaReed 2012-07-12T14:53:36Z Re: Change Query Layer Definition with Arcpy https://community.esri.com/t5/python-questions/change-query-layer-definition-with-arcpy/m-p/460742#M36095 <HTML><HEAD></HEAD><BODY><SPAN>Do you mean the Query Layer's Definition Query?</SPAN><BR /><SPAN>I think you can although I never tried it. You should use ListTableViews function in arcpy.mapping module</SPAN><BR /><BR /><SPAN>See the example here </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/ListTableViews/00s300000006000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/ListTableViews/00s300000006000000/</A></BODY></HTML> Fri, 13 Jul 2012 00:10:19 GMT https://community.esri.com/t5/python-questions/change-query-layer-definition-with-arcpy/m-p/460742#M36095 SolomonPulapkura 2012-07-13T00:10:19Z