Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 101 - 2 questions
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00674789
Message ID:
00674795
Views:
16
< snip >

>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).

You can specify filter condition that always evaluates to False.
SELECT * ;
  FROM mytable ;
  WHERE 1=2 ;
  INTO TABLE mynewtable
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform