Lines Matching refs:table

32 # alter-1.8.*: Tests for ALTER TABLE when the table resides in an 
35 #     table name and left parenthesis token. i.e: 
61     CREATE $::temp TABLE "temp table"(e,f,g UNIQUE);
62     CREATE INDEX i2 ON [temp table](f);
63     INSERT INTO [temp table] VALUES(5,6,7);
68     SELECT * FROM [temp table];
88      table t1                              t1             \
91      table t1'x1                           t1'x1          \
95      table {temp table}                    {temp table}   \
96      index i2                              {temp table}   \
97      index {sqlite_autoindex_temp table_1} {temp table}   \
107     ALTER TABLE [temp table] RENAME to TempTab;
132      table -t1-                         -t1-        \
135      table T2                           T2          \
139      table {TempTab}                    {TempTab}   \
145 # (The TEMP table will not persist, of course.)
162        table -t1-                         -t1-           \
165        table T2                           T2          \
211      table *t1*                         *t1*           \
214      table <t2>                         <t2>          \
298 } {1 {no such table: none}}
306 } {1 {there is already another table or index with this name: t3}}
311 } {1 {there is already another table or index with this name: i3}}
316 } {1 {table sqlite_master may not be altered}}
336 #     table or column name unquoted. This is done because part of the
352     -- Different case for the table name in the trigger.
414 # Make sure "ON" cannot be used as a database, table or column name without
586    WHERE type='table' AND name NOT GLOB 'sqlite*'
651 # Ticket #1665:  Make sure ALTER TABLE ADD COLUMN works on a table
814 # Verify that comments do not interfere with the table rename
855 # Test that it is not possible to use ALTER TABLE on any system table.
865   } [list 1 "table $tbl may not be altered"]
869   } [list 1 "table $tbl may not be altered"]
916 } {1 {error in trigger tr1: no such table: main.logx}}