[VB.NET] Retrieve database structure information.....

[tranky]

Hi....
.....i'd like to know if there's a way to write in a textbox the schema of a
database.
numbers of tables, tables name, numbers of fields, fields name and other
information like fields type, etc...
is it possible? i hope...

please help me...
thank you.

 

[tranky]

i'd like to know if two database have the same structure (fields name,
tables name, fields properties,etc....)

it's possible.....?!?

 

[Ken Tucker [MVP]]

Hi,

Maybe this will help.

Sql server list databases and tables woule have to use sp_columns to list
columns
http://www.windowsformsdatagridhelp.com/default.aspx?ID=9e2d9af4-3909-421d-b422-87c1d376674d

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_4g37.asp

Mysql list databases and tables use Show Columns to list columns
http://www.windowsformsdatagridhelp.com/default.aspx?ID=c6b62715-d07e-4e48-92da-e7603e957de2

http://dev.mysql.com/doc/mysql/en/show-columns.html

Access list tables
http://www.windowsformsdatagridhelp.com/default.aspx?ID=26f91edd-044c-4e71-8c6c-e9d7983c1e05

Ken
--------------------------
Hi....
.....i'd like to know if there's a way to write in a textbox the schema of a
database.
numbers of tables, tables name, numbers of fields, fields name and other
information like fields type, etc...
is it possible? i hope...

please help me...
thank you.