IDatabaseGetSchemaInfo Method

Gets a SchemaInfoCollection describing the specified table or view with SchemaInfo objects for each column. Note that schema information is cached on demand and per-DatabaseID. If the specified table does not exist then an empty (but not null) SchemaInfoCollection will be returned and you can test ObjectExists to determine whether or not the object exists. You can use GetSchemaInfo(String, SchemaInfoType) for various schema object, including tables and views.

Gets a SchemaInfoCollection describing the specified database object with SchemaInfo objects for each column or input parameter. Note that schema information is cached on demand and per-DatabaseID. If the specified table does not exist then an empty (but not null) SchemaInfoCollection will be returned and you can test ObjectExists to determine whether or not the object exists.