select distinct * from table1 into table2>Another one is: How do I query just 1 record using SQL? I just want to create a table which echoes the structure of the database being queried (Yes, I could zap the result, but that sems the ugly way to do it).
select table1 copy structure to table2 with cdx