Reading Database Information Within Code

[Doug]

I'm sure there's a way but I'm not sure of the object that I could use
to do this. I'm wondering if there is some Microsoft SQL object that
would allow me to go out to SQL and for a given database determine what
tables/views/stored procs exist within?

[Rotem925]

well, the answer is yes!, there is a possibility - using the guide schema
please take alook at this code above:
DataTable table = _conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new
string[] { null, null, null, "TABLE" });

using the oledb connection, but it still works on sqlclient either
you can take alook at the msdn for farther information
regrads,
Rotem

--
Rotem
Software & Management Engineer
"Doug" wrote:

I'm sure there's a way but I'm not sure of the object that I could use
to do this. I'm wondering if there is some Microsoft SQL object that
would allow me to go out to SQL and for a given database determine what
tables/views/stored procs exist within?