General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I want to create a new table using all fields of another table
>
>create table products_tmp as;
>select * from products_tbl
>
>The syntax is wrong ????????
>I am working from an ansi standard sql book and I'm stuck !!!!!!
>
>any sample code of other sql basic commands would be great and save me many frustrating hours.
in VFP that would be
SELECT * from Products_tbl into table Products_tmp
if this is a temporary table as the name implies you may want to select into a cursor instead (the cursor is automatically deleted when you close it)
Arnon
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only