> > I know this should be obvious, and I have googled, but how does one 
> > get a list of columns in an SQL table? In this case, I am writing a 
> > script that needs to add data from a form to any of several 
> different 
> > tables where the columns in the tables may be changed by the users 
> > without them having to (or being able to) update the script.
> 
> This works in MySQL but I don't know enough to confirm that 
> it will work in MSSQL.
> 
> show columns from tablename;


The wonderfull thing about standards: There are so many to choose from...
Thanks anyway, but that syntax fails in MS SQL.

---
James.
 

-- 
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist