get table field list using Tsql?

Hello,
Is there a way to get a list of fields in a table using
Tsql?
Thanks,
Ronselect * from information_schema.columns where table_name = 'TableName'
"Ron" <anonymous@.discussions.microsoft.com> wrote in message
news:35ec01c51f4a$d3cb1570$a601280a@.phx.gbl...
> Hello,
> Is there a way to get a list of fields in a table using
> Tsql?
> Thanks,
> Ron|||http://www.aspfaq.com/2177
http://www.aspfaq.com/
(Reverse address to reply.)
"Ron" <anonymous@.discussions.microsoft.com> wrote in message
news:35ec01c51f4a$d3cb1570$a601280a@.phx.gbl...
> Hello,
> Is there a way to get a list of fields in a table using
> Tsql?
> Thanks,
> Ron