sathish
What is mean by view ? and what the use of it ??
By sathish in SQL Server on May 11 2011
  • RMS
    May, 2011 11

    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]

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS