| List: | General Discussion | « Previous MessageNext Message » | |
| From: | David Perron | Date: | August 11 2004 4:36pm |
| Subject: | Indicating an INDEX during TEMPORARY table creation | ||
| View as plain text | |||
When executing: CREATE TEMPORARY TABLE temp_1 AS SELECT * FROM table_name Is it possible to indicate an index within the syntax of this statement - as opposed to issuing an ALTER TABLE command after the table is created? Thanks in advance for any help.
| Thread | ||
|---|---|---|
| • Indicating an INDEX during TEMPORARY table creation | David Perron | 11 Aug |
| • RE: Indicating an INDEX during TEMPORARY table creation | Victor Pendleton | 11 Aug |
