Re: Temp tables and LIKE

You can do the following: select col1, col2 col5, col30, col12 from my_table where 1=0 into temp my_temp_table with no log; You can also use a serial column in the where clause in this way: ... where the_serial_col < 0 (or is NULL when it has been declared not NULL or primary key) Mario R. Canto mcanto@intec.unl.edu.ar On 7 Nov 1997, Bryan Tonnet wrote: } What's the reasoning behind temp tables not allowing the 'LIKE table.column' } syntax in 4GL's version of 'CREATE TABLE'? } } There's a good maintenance benefit in having the facility, as changes to data } types don't need to be tracked through the code (well, not as much anyway). } Seeing as how 4GL is now Category 2 maintenance, I won't bother with an } enhancement request, but I'd be interested in knowing why it wasn't implemented } that way in the past. Different development teams for SQL and 4GL? } } } -- } Bryan Tonnet } batonnet@phase4.com.au }