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";

 

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

Hi,


What you mean with the value?

 

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

Hi,

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.

 

[sloan]

Ok..yeah, thanks for the correction.

dbo. is a typing habit sometimes.

at least I said "experiment with"...