One Reply to “How to Use SQL Views”

  1. It also ensures that the data is visible after the modifications are made permanent.
    The restrictions imposed on views are as follows:
    1. A view can be created only in the current database.
    2. The name of a view must follow the rules for identifiers and must not be the same as that of the base table.
    3. A view can be created only if there is a SELECT permission on its base table.
    4. A SELECT INTO statement cannot be used in view declaration statement.
    5. A trigger or an index cannot be defined on a view.
    6. The CREATE VIEW statement cannot be combined with other SQL statements in a single batch.
    Thanks for useful topic discussion.
    With Regards
    Jazmin Wilss

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.