Listing of table details

[bastienk]

Hi All,

Is there an sp I can query to display / return the schema of an db?


Bastien

Cat, the other other white meat

 

[donutman]

Right click on a table in EM and there is a choice for scripting any/all objects.
-Karl

 

[bastienk]

Thanks, the catch is I need to run this thru ADO...


Bastien

Cat, the other other white meat

 

[dobrios]

sp_help <tablename>

But this returns an Array of recordsets, so you need to
retrieve one you need using something like this

Dim Array() As Object
Dim myRs AS ADODB.Recordset

Array() = call_your_sproc_here(<tableName>)
Set myRs = Array(1)

Hope this helps

 

[MDXer]

select * from INFORMATION_SCHEMA.TABLES -Lists Tables in a DB
select * from INFORMATION_SCHEMA.TABLES - Lests the Columns and the appropriate Table

select * from INFORMATION_SCHEMA.VIEWS - Lists your Views

Look up INFORMATION_SCHEMA in BOL for a complete list.

&quot;Shoot Me! Shoot Me NOW!!!&quot;
- Daffy Duck

 

[dobrios]

Sorry,
That was to get table stats.

 

[bastienk]

MDXer,

Yours is the same solution I found as well...that is what I will use

Thanks All


Bastien

Cat, the other other white meat