MySQL Forums
Forum List  »  MySQL Query Browser

Advanced Search
New Topic

Re: Retrieving column names using sql query
Posted by: francine
Date: July 18, 2005 12:47PM

I found this on another site (it works):

Originally posted by : Nikki
Try this:

SELECT name FROM syscolumns
WHERE id = (SELECT id FROM sysobjects
WHERE name= 'MyTableName')
ORDER by colorder

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.