I have already create a Database in c:\path\db1.mdf.

I also created a Table, table1, and a few Fields: field1, field2, field3, etc.

In SQL I would like to know how to populate a list of each Field in that Table.

I also would like to know how to insert a Field after an existing Field previously mentioned.