how to find table names in given query in sqlserver

SELECT distinct coalesce(db_name(dest.dbID), 
                                db_name(cast(depa.value as int))) AS database_name, 
                                dest.text                         AS [Query],
                                deqs.execution_count              as count,
                                deqs.creation_time                as start_time,
                                deqs.last_execution_time          AS [last_execution_time]

    FROM sys.dm_exec_query_stats AS deqs 
   CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
   CROSS APPLY sys.dm_exec_plan_attributes(deqs.plan_handle) depa 
    WHERE dest.text LIKE 's%' 
     and (depa.attribute = 'dbid' AND depa.value = db_id(databasename) 
     or dest.dbid = db_id(databasename))