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: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 44:49:35 |
Calls: | 8,810 |
Calls today: | 6 |
Files: | 13,307 |
Messages: | 5,972,307 |