I am trying to build a dynamic database map that will return a page that shows each Table in the database along with the Column names and the datatype of each column in a rather large Microsoft SQL Server database. I know how to extract the column names for the tables, as well as the datatypes of the column...but for the life of me I can't figure out the SQL query to use to retrieve a list of the tables a database contains. It is important that the script be able to account for changes to the database.
Does anyone know the SQL to extract the user created tables in a MSSQL database? Thanks, Ron -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
