mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 22:39:05 +00:00
24 lines
507 B
Plaintext
24 lines
507 B
Plaintext
|
|
ALTER TABLE t5 DROP COLUMN new_col_1;
|
|
|
|
|
|
ALTER TABLE t5 DROP COLUMN new_col_1;
|
|
SELECT 1 FROM sqlite_schema WHERE name='t5' AND sql LIKE '%new_col_1%';
|
|
|
|
|
|
SELECT 1 FROM sqlite_schema WHERE name='t5' AND sql LIKE '%new_col_1%';
|
|
|
|
|
|
SELECT name FROM pragma_table_info('t1') ORDER BY cid;
|
|
|
|
|
|
SELECT name FROM pragma_table_info('t1') ORDER BY cid;
|
|
|
|
|
|
SELECT name FROM pragma_table_info('t1') ORDER BY cid;
|
|
|
|
|
|
CREATE TABLE t7(a, b, c);
|
|
CREATE VIEW v7 AS SELECT * FROM t7;
|
|
|