I am new to SQL and am having a few simple problems that i cannot find solutions to on the web. Firstly I was wondering if there is any simple SQL command that will find the column names of a table. All sql tutorials seem to already know this. It is quite simple to do this using another database for the column names but this seems to be a clumsy solution.

Also I am using perl cgi scripts with the DBI module and the CSV type of database. Most SQL commands work with my code perfectly however a few random keywords and commands do not (such as auto_increment and ALTER TABLE) Is this a result of using CSV databases because of their extreme simplicity or is there something more sinister at work?

thanks so much

Liam Skoyles

for the first sp_tables. For the second, I have no idea