SQL 2005 - call to get all tables in a DB

[JPS]

What kind of a query do I use when all I want to do is get a lst of al
of the tables in a database and their fields. I'm trying to get schema
information and GetSchema give you the field type but not the value.
Theis (below) does not work.

sqlCmd.CommandText = "SELECT * FROM INFORMATION_SCHEMA.COLUMNS";
SqlDataReader sqlDr = sqlCmd.ExecuteReader ( );

[sloan]

the db is the "master".

so, in your connect string, specify it, or
you can experiment with

"SELECT * FROM master.dbo.INFORMATION_SCHEMA.COLUMNS";

"JPS" <jp*****@yahoo.comwrote in message
news:11**********************@i39g2000hsf.googlegr oups.com...

What kind of a query do I use when all I want to do is get a lst of al
of the tables in a database and their fields. I'm trying to get schema
information and GetSchema give you the field type but not the value.
Theis (below) does not work.

sqlCmd.CommandText = "SELECT * FROM INFORMATION_SCHEMA.COLUMNS";
SqlDataReader sqlDr = sqlCmd.ExecuteReader ( );

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
What you mean with the value?

"JPS" <jp*****@yahoo.comwrote in message
news:11**********************@i39g2000hsf.googlegr oups.com...

What kind of a query do I use when all I want to do is get a lst of al
of the tables in a database and their fields. I'm trying to get schema
information and GetSchema give you the field type but not the value.
Theis (below) does not work.

sqlCmd.CommandText = "SELECT * FROM INFORMATION_SCHEMA.COLUMNS";
SqlDataReader sqlDr = sqlCmd.ExecuteReader ( );

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"sloan" <sl***@ipass.netwrote in message
news:Ot**************@TK2MSFTNGP03.phx.gbl...

the db is the "master".

so, in your connect string, specify it, or
you can experiment with

"SELECT * FROM master.dbo.INFORMATION_SCHEMA.COLUMNS";

In 2005 at least you have a INFORMATION_SCHEMA.COLUMNS in the DB itself,

And btw you CANNOT prefix it with dbo. INFORMATION_SCHEMA. is the correct
owner.

--
Ignacio Machin
machin AT laceupsolutions com

[sloan]

Ok..yeah, thanks for the correction.

dbo. is a typing habit sometimes.

at least I said "experiment with"...

"Ignacio Machin ( .NET/ C# MVP )" <machin TA laceupsolutions.comwrote in
message news:Oi**************@TK2MSFTNGP06.phx.gbl...

Hi,

"sloan" <sl***@ipass.netwrote in message
news:Ot**************@TK2MSFTNGP03.phx.gbl...

the db is the "master".

so, in your connect string, specify it, or
you can experiment with

"SELECT * FROM master.dbo.INFORMATION_SCHEMA.COLUMNS";

In 2005 at least you have a INFORMATION_SCHEMA.COLUMNS in the DB itself,

And btw you CANNOT prefix it with dbo. INFORMATION_SCHEMA. is the

correct

owner.

--
Ignacio Machin
machin AT laceupsolutions com