4 Displaying Database View Content

Once a view has been created, you can display the content of the view.

1. Type SELECT * FROM <ViewName>.
   For example, SELECT * FROM AssetReport.

   Note:

   To specify the name of a view that has spaces in its name, surround the view name with square parentheses, for example SELECT * FROM [Asset Report]. To specify the name of a view that has square parentheses in its name, surround the entire view name in square parentheses. For example, if the view is called 'Asset Report [London]', use SELECT * FROM [Asset Report [London]]
2. Click Run.