Database Reference
In-Depth Information
Figure 8-17: View design window.
The columns are automatically added to the SQL statement (see Figure 8-18).
4. After you have finished selecting all the columns and tables you want to add, click the Save
icon on the menu bar.
5. Enter the view name.
Make sure to follow a standard naming convention to make it easier to maintain the system.
Here are some common conventions for naming objects in SQL server:
Limit the name to approximately 50 characters (the shorter the name, the better).
Avoid using spaces in the name. Instead, use camel case (using uppercase for the first
letter of each word, as in SalesAmount).
Avoid using numbers and underscores in the name.
Search WWH ::




Custom Search