You can use
select * from information_schema.columns where table_name='mytable' for that.
HTH
>I have a side question on this one. In my app, I need to read the table structure from a MSSQL2K database and then do my "Create Table" structure. Do you know how I might easily do that with ADO (using the Connection object reference to my MSSQL2K box)?
>
>So I would be able to code:
>
>arStructure = oConnMSSQL.Execute("GiveMeStructureOf ThisTable").GetRows
>
>Then I could have an array that I could parse/feed to my VFP database, giving me a mirrored structure.
>
>What do you think?
>
>
>>I think for this it's easier to use the connection's execute method to send regular VFP SQL commands:
>>
oConn.Execute "CREATE TABLE myTable (iID i PRIMARY KEY, desc c(30))"
>>This creates the table with a couple of fields with iID being the primary key.
>>HTH