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 creationDavid Perron11 Aug
RE: Indicating an INDEX during TEMPORARY table creationVictor Pendleton11 Aug