SQL 7 column names

Dev Shed Forums Sponsor:

May 9th, 2003, 12:17 PM

don_sparko

Digitally Challenged

Join Date: May 2003

Posts: 280

Time spent in forums: 54 m 14 sec
Reputation Power: 6

SQL 7 column names

i'm using sql 7 and i need to get the column names. i can see them using sp_columns tableName but it returns alot of junk that i don't need. anyone know a way to get JUST the column names?

thanks

May 9th, 2003, 03:38 PM

Scorpions4ever

Banned ;)

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Nov 2001

Location: Glendale, Los Angeles County, California, USA

Posts: 7,587

Time spent in forums: 1 Month 1 Day 21 h 15 m 52 sec
Reputation Power: 997

Code:

SELECT 	c.[name]
FROM		syscolumns AS c WITH (NOLOCK)
INNER JOIN 	sysobjects AS s WITH (NOLOCK)
ON 	c.id	= s.id
AND 	s.[name]	= 'MyTableName'

Hope this helps.

December 5th, 2003, 08:21 AM

motin

Contributing User

Join Date: Oct 2003

Posts: 72

Time spent in forums: 7 h 26 m 45 sec
Reputation Power: 5

For mysql

I understand the creator of this thread has his issue solved, but for all who wants an answer on this question, and using mysql, here it is (dead simple ey?):

SHOW COLUMNS FROM table_name

Viewing: Dev Shed Forums > Databases > Database Management > SQL 7 column names

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump