Hi
How do I export column heading to a file? Or list them.
BR
Gjerde"select table_name, column_name from information_schema.columns"
As a one-off you could run the following in SSMS and set the "Results to
file" option.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Hello,
sp_columns <table_name>
or
sp_help <tableName>
Thanks
Hari
"H.Gjerde" <hg@.norspace.no> wrote in message
news:uNo2RCNNHHA.5104@.TK2MSFTNGP06.phx.gbl...
> Hi
> How do I export column heading to a file? Or list them.
> BR
> Gjerde
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment