To view the SQL statement on which a user-defined table is based:
In the Data Source Navigator, under Data Sources in the physical tree, navigate to a user-defined table.
Right-click the table and select Properties, and then select the User-Defined Statement tab.
The SQL statement on which the user-defined table is based is displayed.