Get column names in a table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Harsha Majety » Get column names in a table

Get column names in a table

Rate Topic

Display Mode

Topic Options

Author

Message

harsha.majety

Posted Saturday, December 04, 2010 11:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:28 PM
Points: 6, Visits: 396

Comments posted to this topic are about the item Get column names in a table

Post #1030299

SqlSpider...

Posted Sunday, December 05, 2010 10:00 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 6:45 AM
Points: 84, Visits: 269

Hi To find column in a table you posted a code but it is getting results... Here I am posting the code to get column in the table that is also same it is getting results.... but for this i am getting results for one table... but i need all the tables column names in the DB... Plz give me query for that....

SELECT Column_Name 'Column Name',
Data_type 'Data Type', character_maximum_length 'Maxium Length'
FROM information_schema.columns WHERE table_name = 'Table_Name'

Smile

suresh

Post #1030437

harsha.majety

Posted Monday, December 06, 2010 6:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:28 PM
Points: 6, Visits: 396

SELECT Column_Name 'Column Name',table_name 'Table_Name;
Data_type 'Data Type', character_maximum_length 'Maxium Length'
FROM information_schema.columns
GROUP BY table_name

Post #1030548

phelmer

Posted Monday, December 06, 2010 11:19 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:11 PM
Points: 278, Visits: 430

Suresh, to get that information for all tables in the database, remove the WHERE clause from the original query.

Post #1030746

« Prev Topic | Next Topic »

Permissions