Re: lasting databases, tables, columns

Thanks Peter!

You say .Net 2005...are you to mean SQL 2005 (and possibly sql2000/sql 7)?

  - dave

p.s. saw your post on sswug too.  I'll say the most direct ways is for tables and column information is
INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS.  I don't particularly like accessing
master.dbo.sysdatabases or even the system sprocs for this, because of the different between sql2k and sql2k5.

Peter Osucha wrote:
> Yes, David.  I have always learned a lot from code you have pointed people
> to on the VASBAS-L list.  The only other thing I have thought about doing at
> this time is using the system stored procedures sp_databases, sp_columns,
> etc., and making some simple object to hold the info myself.
>
> Peter
>
> -----Original Message-----
> From: David L. Penton
>
> I have something using the ODBC API.  You interested in it?
>
> Peter Osucha wrote:
>> I have been searching MSDN and some other websites today for an SQLDMO
>> like solution for getting the databases in a SQL server instance, the
>> tables in a database, and the columns in a table - without much luck.
>> What is the
>> *best* way to go about doing this in NET 2005?
>>
>> Sincerely,
>> Peter

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com