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: Tuesday, June 11, 2013 1:29 PM
Points: 6, Visits: 399

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, June 12, 2013 1:41 AM
Points: 84, Visits: 271

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: Tuesday, June 11, 2013 1:29 PM
Points: 6, Visits: 399

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: Monday, June 10, 2013 11:25 AM
Points: 278, Visits: 436

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