mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-15 01:25:30 +00:00
12 lines
229 B
Plaintext
12 lines
229 B
Plaintext
|
|
CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y;
|
|
SELECT * FROM "new view";
|
|
|
|
;
|
|
SELECT * FROM sqlite_master WHERE name = 'new view';
|
|
|
|
|
|
DROP VIEW "new view";
|
|
SELECT * FROM sqlite_master WHERE name = 'new view';
|
|
|