[Wylug-help] ODBC and SQLServer

[Dave Whiteley]

David,

Thanks,

You are duly awarded the "Most Useful First Post of the Year (so far)
Award, 2004.

Cheers

Dave




On Thu, Jan 08, 2004 at 10:24:25AM -0000, David Turner wrote:
> Hi Dave,
>
> My first post to the group so hello (and Happy New year) to everyone.
>
> I am assuming that when you say SqlServer you are referring to Microsoft SQL
> Server.
>
> The following query should do it.
>
> use <databasename>
> select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1
>
> Also goto www.microsoft.com/sql and download the online books for SQL, it is
> actually the best documentation i have seen from m$
>
> hth and apologies if I have got the wrong end of the stick.
>
>
>
>
>
> david.
>
> -----Original Message-----
> From: wylug-help-admin at wylug.org.uk
> [mailto:wylug-help-admin at wylug.org.uk]On Behalf Of Dave Whiteley
> Sent: 07 January 2004 15:26
> To: wylug-help at wylug.org.uk
> Subject: [Wylug-help] ODBC and SQLServer
>
>
> 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?
>

--

Dave Whiteley
d.l.whiteley at ee.leeds.ac.uk
Phone +44 (0)113 343 2059
School of Electronic and Electrical Engineering
The University of Leeds. Leeds, LS2 9JT,  UK