SELECT

[qp].[query_plan]

FROM sys.dm_exec_cached_plans cp

CROSS APPLY sys.dm_exec_sql_text ( cp.plan_handle ) st

CROSS APPLY sys.dm_exec_query_plan ( cp.plan_handle ) qp ;

1) If we execute this query it returns result in xml code.

2) If we click that xml code it opens executionplan.sqlplan tab in ssms it shows Graphical Execution plan.

I am trying to findout how it works internally......:crying:

Please let me know if anyone knows.