In SQL Enterprise Manager, when you expand a database you are shown the database's tables, views, stored procedures, and other useful database objects. Not surprisingly, SQL Server uses a table to store the object information for each database. Let's say that you wanted to display the tables in your database on a web page. All of the tables in your database are stored in the sysobjects table, so all you need to do is properly query the sysobjects table. There is a column in the sysobjects table named Type , which is used to differentiate between each type of database object.
Tables are of type U , as in u nderwear.
So all we need to do is query the sysobjects table for rows that have a U in their Type field. Display the results in a table Response. For Each fld in objRS.Fields Response. While not objRS.EOF Response. For Each fld in objRS.Fields Response.