[Wylug-help] ODBC and SQLServer

Nick Gorham nick at easysoft.com
Wed Jan 7 21:10:28 GMT 2004


Dave Whiteley wrote:

> Hello,
>
> Sometime ago I asked about ODBC, and got a load of useful replies.  I
> am now working on this again, and I Think that I am now connecting
> sucessfully to the SqlServer.  I am not sure, because I cannot submit
> any queries, because I do not yet know what tables there are there.
> If I had been using MySql I would have used a query like "Show
> Tables".  Does anyone know what would do the same job for the
> SqlServer?
>
> Ta,
>
> Dave

Depends on what you are using to connect, if unixODBC and isql then just
entering help at the prompt will issue a SQLTables call to get a list of
tables.

--
Nick Gorham
Easysoft Limited





More information about the Wylug-help mailing list