1
Reply

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

sathish

sathish

May 11, 2011
4.3k
0

    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]

    RMS
    May 11, 2011
    0