Simple sql questions (broken commands and retrieving columns)

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

lskoyles

Newbie Poster

1 post since Jul 2005

Reputation Points: 10

Solved Threads: 0

6 Years Ago

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

campkev

Posting Pro in Training

484 posts since Jul 2005

Reputation Points: 14

Solved Threads: 19

This article has been dead for over three months

You