- Notifications
You must be signed in to change notification settings - Fork689
Create View
Mathias Rangel Wulff edited this pageJun 11, 2015 ·3 revisions
Syntax:
CREATEVIEWviewid [(column, ...)]ASselect
AlaSQL supports CREATE VIEW statement:
alasql('create table city (name string, population number); \ create view bigcity (name) as select name from city where population > 1000000; \ insert into city values ("Moscow",11500000), ("Berlin", 3500000), ("Yoshkar-Ola",250000)');alasql('insert into city values ("New York",16000000)');
Try this examplein jsFiddle
See also: [DROP VIEW](Drop View)
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo