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 .. .. ..
