Fetching query from query layer using ArcObjects and C#?

Question

As shown in the image below, I need to fetch query mentioned within query section of a layer using ArcObjects in C#.

 IDocument doc = ArcMap.Application.Document;
 IMxDocument mxDoc = doc as IMxDocument;
 IMap map = mxDoc.FocusMap;
 ILayer mapLayer = map.get_Layer(0);
 IFeatureClass c = (mapLayer as IFeatureLayer).FeatureClass;

enter image description here

• Mapperz: Comments are not for extended discussion; this conversation has been moved to chat.

Answer 1

Cast the layer to an IDatalayer2. Cast IDataLayer2.DataSourceName to IQueryTableName Get the SQL from IQueryTableName.Query

• jay: Thanks bro. It worked like a charm. Did you check the answer i posted for a question that we were trying to solve. [link]gis.stackexchange.com/questions/286127/…