SQL Server – list table columns for a particular table

[sql]</pre>
select TABLE_NAME, COLUMN_NAME

from INFORMATION_SCHEMA.COLUMNS

where TABLE_NAME=’PIPING’

order by TABLE_NAME, ORDINAL_POSITION
<pre>
[/sql]