Mohan Cheema's Online Diary

Site Just to Keep Track of My Day to Day Work.

September 1, 2010
by Mohan Cheema
0 comments

How to get MySQL table Column Names without MetaData

Often we need to list just the column name of the table without displaying the metadata. However, Until before MySQL 5.0 there was no way to get just the column names for any given table. Since MySQL 5.0 new table has been added information_schema. INFORMATION_SCHEMA provides access to database metadata.

Share
Share