Retrieving Column Names of Table in MySQL, SQL Server

When you do select query that will give you only records available,
in some conditions we may require Column names of table for dynamic query generating programs for that purpose here is the query for retrieving Column Names

In MySQL :

SHOW COLUMNS FROM <table name>

In SQLServer

Select column_name from information_schema.columns where table_name =<tablename>

for more infomation on table try with
select * from inormation_schema.columns where table_name=<table name

!!happy coding…!!

P.S. : Please post us Your Valuable Comments on this Article

Written by : adrevol
( Treats Given : 35 Treats Attended : )