Check out sp_help <tablename>
In article <4d5nol$gln@maverick.tad.eds.com>, "Robert M. Zegarac" <lnusspo1.gzkgl5@eds.com> writes:
Is there an easy was in ISQL to list the columns contained in a table?
I find myself in ISQL and don't remember col names I want to query on. Then I have to dig out the doco. I vaguely remember a command (I think
it was DRAW) that was used in QMF (DB/2) to create a query that listed every column. Is there something similar? TIA.
--
--
Robert M. Zegarac
lnusspo1.gzkgl5@eds.com
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Terry Miesse | All opinions are mine.
LEXIS/NEXIS | All quotes are somebody else's.
I/S Production Services |
(513) 865-6800 x6711 | Do what you always did terry.miesse@lexis-nexis.com Get what you always got ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 349 |
Nodes: | 16 (0 / 16) |
Uptime: | 143:33:42 |
Calls: | 7,613 |
Calls today: | 1 |
Files: | 12,790 |
Messages: | 5,684,508 |