How to get Column Names

This site is best viewed in a modern browser with JavaScript enabled.

FrazierEvans

Unfortunately the developers of the documentation for the product I am using is severely lacking. It is based on a locked down appliance that they do not give access to. (I know, not the best situation to be in and not my design, I inherited it).

I can get a list of the tables that are part of the Database, not easy bit done.

I would normally just do a

Select * from [table];

I understand that is not an option and get the why, Is there another way to accomplish the same thing. I am new to Reportico and like what I see just wish I could get what I need / want out of the database behind it.

Thanks in advance,

Frazier

peterdeed

Hi there .. in order to look at the structure the database you might be able to install an application into the web server called phpmyadmin which will allow you to open database, browse the tables and columns.

If you needc to use reportico to do that then you can create new report... open the sql text box and paste in the following

SELECT table_name,GROUP_CONCAT(column_name ORDER BY ordinal_position)
 columnname
FROM information_schema.columns
WHERE table_schema = DATABASE()
GROUP BY table_name
ORDER BY table_name

that will give you a summary view,

or to show one line per column do

SELECT table_name,column_name
FROM information_schema.columns
WHERE table_schema = DATABASE()