A fast way to get a list you can copy into a code file with all the fields in a table.
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ‘tablename’
A fast way to get a list you can copy into a code file with all the fields in a table.
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ‘tablename’