Getting table and column names in MS SQL

[dbrom]

Hi guys,

I am trying to develop an interface for the database so that a user with minimum knowledge would be able to write SQL queries from my ASP pages. I just want to do this for UPDATE, DELETE, INSERT, SELECT.
So I thought it would be very nice if I could first ask user to delect a table, then specific fields from a drop-down list. Do you know if it is possible - can I access table names and fiels names in MS SQL?

Thanks in advance. Dmitriy
dbrom@crosswinds.net

 

[GlennBSI]

go to SQL Server Enterprise manager (or the SQL snap-in to management console) and look into the systables and syscolumns tables. They have info on all the tables and the columns in each. You'll need to look at the table type (don't recall the exact column) to only select from user type tables.

 

[dbrom]

Thanks...

I did what you suggested and looked at syscolumns table.
Strangely, I could not find the other one, systables table.
I found the columns from my tables in syscolumns, so at least I got some idea how to proceed.

tjanks again Dmitriy
dbrom@crosswinds.net

 

[GlennBSI]

My memory isn't so great, so it could be that the systables table doesn't exist.

If not, then I guess you need to select all the columns that have the same tablename (if that's shown in the syscolumns table).

Sounds like you're on the right track though. Have fun!