Re: Eliminate System Table/Column using OpenSchema in VB6

rejuso@xxxxxxxxx wrote:
Hi everyone! I am new in this group. Please kindly help me.
I am using Sybase SQL Anywhere 5.0.03 and Visual Basic 6.0.
There is no problem in using OpenSchema method of ADODB.Connection,
except that it displays even the system tables/columns of the
database.
I only want to display the non-system tables/columns.
How could I do that?

--------------------------------------------------
Is there a field that could determine if the table/column is system or
not.

An ADOX Table object has a Type property which, if the OLE DB Provider
supplies the information, should contain a string indicating if the
table is a system table. See
http://msdn2.microsoft.com/en-us/library/ms676602.aspx

Is there any way without using ADOX?

There will probably be system tables you can query for this information
in Sybase. I can't help with the specifics. If you get no help here, try
posting to a Sybase group.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Central and terminal services...
    ... I mean that there are TeamSybase folks helping out in the forums, as well as some Sybase employees; but all of this activity is on a purely voluntary basis] ... - consider searching newsgroup histories ...
    (comp.databases.sybase)
  • Re: order by where....
    ... > Or Sybase. ... > But I should think instr() would do the job in Oracle or MySQL... ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)