arcPy on query layer

Question

I need to make many MXDs which include query layers (NOT through layer definition).  The difference of these MXDs is only the query of the layer.  Is there way to automate this?

Thanks.

BillDaigle · Answer

Only way I know is to do a describe on the layer and look for the string "%" in the datasetName property.

RonnieRichards · Answer

Is it even possible to detect a if a layer is a query layer using ArcPy?

MikeVolz · Answer

I see the Make Query Layer in the Data Management->Layers and Table Views Toolbox which is great.

I would also like to know if there is the ability to edit a Query Layer, that is already created, through python.  In my scenario, I see many Query Layers created with an Oracle 11g Client connection.  If the back end database gets updated to Oracle 12c (which my organization will probably do within the next 2 years), I would want to update the Query Layer to use the Oracle 12c Client connection instead of the Oracle 11g Client connection.  Is this scenario currently possible through python?