View examples  create view syntax

Chapter 11: Views: Limiting Access to Data

Creating views

View names must be unique for each user among the already existing tables and views. If you have set quoted_identifier on, you can use a delimited identifier for the view. Otherwise, the view name must follow the rules for identifiers given in “Identifiers”.

You can build views on other views and procedures that reference views. You can define primary, foreign, and common keys on views. However, you cannot associate rules, defaults, or triggers with views or build indexes on them. You cannot create temporary views or views on temporary tables.





Copyright © 2005. Sybase Inc. All rights reserved. create view syntax

View this book as PDF