>I believe the syntax for commands is just regular SQL. I connected to a database and ran a couple SELECT commands on a table I knew existed and they seem to work. Where can I find a resource for SQL commands that are not Foxpro-specific? Specifically looking for commands to list the tables in the database and stuff like that. I know in Foxpro, but they don't work for me in this utility. Thanks!
>
>UPDATE: I tried "show tables" but it didn't recognize "show" as a command. Is this not really SQL I'm dealing with?
Try Toad for SQL serer (
http://www.toadsoft.com/ - mind you, there's Toad for Oracle, for MySql etc). I's your Enterprise Manager, Query Analyzer and Browse command bundled in one. Resource intensive, but powerful and free.