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. In the Data Source Navigator, under Data Sources in the physical tree, navigate to a user-defined table.

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