Viewing the Statement on Which a User-Defined Table is Based

  To view the SQL statement on which a user-defined table is based:

  1. From the Source Navigator, select the Data Sources tab.

  2. Under Data Sources in the physical tree, navigate to the user-defined table whose SQL statement you want to view.

  3. 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.