Does anyone know if there's any way to get a table's attribute names (using an SQL query or something like that)


i found that i can get the tables names using this query:


SELECT Name from MSysObjects where Type = 1


MSysObjects is a system table in MS ACCESS holding information about the DB objects (Tables, relationships, etc.)

Apparently theres no Table specifying the DB table's attributes.

i need to implement a PowerBuilder function that receives a valid table name and returns an array of strings containing the names of each of the table attributes.


Any help?

There is a ton of information at MSDN about Defining and retrieving a database's schema. I don't think it will be too hard to do using PowerBuilder, but you won't be able to just paint a DataWindow from a SQL SELECT statement.

-PatP