On 8/3/07, James Newton, Host wrote: > 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; -- http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist