Thanks for your reply Sergey. I think I downloaded the SQL book a long time ago in a different job.
The reason I am using osql at this point is that I am evaluating if we should switch to a different database in our product. We are currently using Advantage Database Server.

Are Enterprise Manager and Query Analazer also free like MSDE? I seem to remember that they are not.

Again thanks for your reply Sergey.

Einar

>>I am drawing a blank here. What command do I use in osql to list the tables in a database?
>>Also I can't remember what command I used to view fields (columns) in a table.
>>
>>If anyone knows of a great webpage where some of this type of information can be found I would appreciate if you could send me the link.
>
>Hi Einar,
>
>The best reference I know is SQL Server 2000 Books Online (Updated 2004)http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp. Any particular reason why you're using OSQL and not Enterprise Manager and Query Analazer?