Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Table Names in MSSQLServer

0 views
Skip to first unread message

marcelino varas

unread,
Nov 28, 2001, 7:40:04 AM11/28/01
to

Hi:
How can I do to obtain the table names in a database ?
I'm connected to a MSSQLServer with the native driver.
I tried with the Session object but have an error : acces violation at the module SQLMSS32.DLL

Jim Elden

unread,
Nov 28, 2001, 8:13:10 AM11/28/01
to
Marcelino,

SELECT * FROM Information_Schema.Tables

HTH,
Jim


Steve Troxell

unread,
Nov 28, 2001, 8:15:11 AM11/28/01
to
If you want to run a query:

SELECT name FROM sysobjects WHERE type = 'U'

or

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE
TABLE'

If you're getting access violations using Session.GetTableNames, sounds like
something is wrong in your BDE/SQLLinks/SQL Server client installation.
--
Steve
http://www.krell-software.com
Database Development Tools for MS SQL Server


"marcelino varas" <vr...@mediatechnic.de> wrote in message
news:3c04db24$1_1@dnews...

marcelino varas

unread,
Nov 28, 2001, 8:39:16 AM11/28/01
to

What can be wrong in the instalation ?
I don't want to do a query if it's posible.
Thanks.

MrX

unread,
Nov 29, 2001, 6:08:00 PM11/29/01
to
You always should try to make it as transparant as possible, so I wouldn't
prefere the solutions above, 'cause they are all MS SQL specific...


"marcelino varas" <vr...@mediatechnic.de> wrote in message
news:3c04db24$1_1@dnews...
>

0 new messages