A View is a virtual or imaginary table based on the outcome of a SELECT statement.

Views in SQL

     

A View is a virtual or imaginary table based on the outcome of a SELECT statement. A view include rows and columns as real table. A view include a fields is similar to one or more real tables in database. A view of a table does not store a data.

Understand with Example

The Tutorial illustrate an example from 'View in SQL'. To understand this example we create a table 'customer'. The create table is used to create a table customer with required field attribute and data type respectively.

 

 

 

 

Create Table 'customer':

create table customer(First_Name varchar(15),Last_Name varchar(15),Address varchar(15),City varchar(15),Country varchar(15));

Insert values into Table 'customer':

The insert into add the records or rows to the table 'customer'.

To see the detail of table 'customer':

The Select keywords returns you the set of records from table 'customer'.

select * from  customer;

 

Create View 'viewCustomer':

Now we apply view on Table 'customer'. The create VIEW is used to create a view 'viewCustomer' that contain the first_name,last_name and country field name  from table 'customer',

create VIEW viewCustomer as SELECT First_Name,Last_Name,Country FROM Customer;

View Details :

The select  return the set of records or rows from 'viewCustomer'.

select * from viewCustomer;

Output is displayed as :

Related Tags for Views in SQL:
c,  database,  com,  table,  data,  select,  include,  view,  tables,  sed,  virtual,  column,  vi,  field,  state,  columns,  fields,  tab,  utc,  row,  rows,  ie,  statement,  to,  base,  store,  ld,  ws,  e,  il,  not,  im,  in,  no,  real,  as,  sta,  m,  nt,  out,  agi,  based,  cl,  es,  em,  ase,  me,  gina,  do,  tor,  similar,  umn,  s,  gin,  col,  at,  inc,  is,  ir,  ea,  and,  ar,  stat,  tco,  rt,  sim,  s,  s,  th,  st,  ab,  abl,  lds,  lum,  mi,  nd,  on,  om,  ol,  o

More Tutorials from this section

• Mysql Alter Column
• Mysql Alter Data Type
• Mysql Alter Table
• MySQL Alter Tutorial, Database MySQL MySQL Crash Tutorial Tutorial
• Mysql add primary key
• Mysql Alter Add Column
• Mysql Alter Add Multiple Columns
• Mysql Alter Autoincrement
• Mysql Alter Column Datatype
• Mysql Alter Column Default
• Mysql Alter Column
• Mysql Alter Column Primary Key
• Mysql Alter Column Size
• Mysql Alter Column
• Mysql Alter Command
• Mysql Alter Constraint
• Mysql Alter Data Type
• Mysql Alter Drop
• Mysql Alter Foreign Key
• Mysql Alter Multiple Columns