Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP .Net (http://www.velocityreviews.com/forums/f29-asp-net.html)
-   -   Extracting Tables and columns with data types from a database (http://www.velocityreviews.com/forums/t103835-extracting-tables-and-columns-with-data-types-from-a-database.html)

RSH 06-02-2005 01:25 PM

Extracting Tables and columns with data types from a database
 
Im trying to write a simple app that will show all of the user created
tables along with their columns and column datatypes.

Any suggestions on how to approach this???

Thanks!



Eliyahu Goldin 06-02-2005 02:43 PM

Re: Extracting Tables and columns with data types from a database
 
For this you need to access the database metadata. In SQL server you can
obtain metadata either with system stored procedures or with information
schema views. Search your database documentation for "metadata".

Eliyahu

"RSH" <way_beyond_oops@yahoo.com> wrote in message
news:uZQ%23Ca3ZFHA.2076@TK2MSFTNGP15.phx.gbl...
> Im trying to write a simple app that will show all of the user created
> tables along with their columns and column datatypes.
>
> Any suggestions on how to approach this???
>
> Thanks!
>
>





All times are GMT. The time now is 09:49 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.