1
Reply

What is mean by view ? and what the use of it ??

sathish

sathish

13y
4.4k
0
Reply

    A view is an "Virtual Table". It is not like a simple table, this is an virtual table which contains columns and data from different table ( may be one or more tables) . View does not contain any data directly, it is a set of query that are applied to one or more tables that is stored within the database as object.

     

    Syntax:

    CREATE VIEW  [View Name]
    AS
    [SELECT Statement]