Get column names in a table

Question

Get column names in a table

harsha.majety

SSCommitted

Points: 1537
More actions
December 4, 2010 at 11:40 am

#241982

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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SqlSpider... Ten Centuries Points: 1254 More actions · Answer 1

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'

:-):-)suresh:-):-)

harsha.majety SSCommitted Points: 1537 More actions · Answer 2

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

phelmer SSChasing Mays Points: 633 More actions · Answer 3

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

Phil Helmer
Database Engineer

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

akljfhnlaflkj

SSC Guru

Points: 76202

May 17, 2016 at 12:46 pm

#1879669

Thanks for the script.

Get column names in a table

Cookies on SQLServerCentral