Reading Database Information Within Code

  • Thread starter Thread starter Doug
  • Start date Start date
D

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?
 
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
 
Back
Top