Hola Juan,
> Anyone knows how can I get the metadata information from DB ? (ie.
tables,
> fields, primary keys, datatypes, views)
In MsSql you can use the StoredProcs such called sp_tables witch will
return all
the tables in a DB including the sys tables. There are other that do
different things , sp_columns etc...
In Access you can get at the table names from a systable , it's called
MsysObjects ,but it has alot of other stuff in there. To view the table in
access go to tools->options->view and tick
hidden objects and system objects
Hasta Lleugo
~Justin MacCarthy
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
