SQL Server – list table columns for a particular table

</pre>
select TABLE_NAME, COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS

where TABLE_NAME='PIPING'

order by TABLE_NAME, ORDINAL_POSITION
<pre>