[web] SQL + Column Names

I recall from my mysql days using something like "show databases" and "show tables"

no clue if it's the same for mssql.

in oracle you can use:

table names:
select table_name from user_tables;

column names:
select column_name from user_tab_columns whre table_name = 'MYTABLE'


Lazzar

There are two ways.

One is by reading from the system (sys*) tables. For example this will return a list of all tables in the database:

SELECT name FROM sysobjects WHERE xtype='U'

I suggest you lookup the documentation on MSDN (or buy a copy SQL Server to get the big poster) for more information (you can read everything about the database from the sys* tables, including tables, columns, indexes, contraints, etc).

The other way (probably easier if you are using ASP) is by using an ADOX catalog. For example to do what we did above (note that this is actual ASP script, using VBScript as the language):

Set Connection = Server.CreateObject("ADODB.Connection")Connection.Open "blah"Set Catalog = Server.CreateObject("ADOX.Catalog")Catalog.ActiveConnection = ConnectionFor Each Table in Catalog.TablesResponse.Write Table.Name & "
"Next

As before, you can get all the information you want, just read the properties (lookup the reference on MSDN for all the properties)

Also: sp_help will show all objects in the database. Supply it an object name (eg: MyTable) and it'll show a bunch of info about it, including the column specs... But Michalson's way is probably the most practical.