> > I know this should be obvious, and I have googled, but how does one > > get a list of columns in an SQL table? > > I seem to remember "show columns from" from my mysql days. > I'm not sure if it's standard, but it's worth a shot. That seems to be popular, but it throws a syntax error in M$ SQL Server 7.0. Thanks anyway. --- James. -- http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist