To view the SQL statement on which a user-defined table is based:
From the Source Navigator, select the Data Sources tab.
Under Data Sources in the physical tree, navigate to the user-defined table whose SQL statement you want to view.
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.