>>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.
I'm using TOAD for Oracle at work and I find it to be a very good product.
I'd say 'excellent' but for the fact that I can't find a way to make it open a bunch of BROWSERs (tables I use all the time with columns re-ordered/re-sized) automatically.
cheers