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: | 251 |
Nodes: | 16 (3 / 13) |
Uptime: | 15:35:53 |
Calls: | 5,567 |
Calls today: | 6 |
Files: | 11,682 |
Messages: | 5,126,003 |
Posted today: | 1 |