Skip to Main Content
Forums

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to extract the column names from multiple tables at a time.

Mickel JohnFeb 28 2017 — edited Mar 1 2017

Hi,

I need to extract the only all columns names from multiple tables at a time.

Ex:--

Table_1

id  name  address

----------------------

2  John      UK

Table_2

Uid  f_name  Location

----------------------------

12    Mack      NJ

After running query , i want  only column names only i.e id, name, address and Uid,f_name, Location only.

Please help me,

Thank you.
This post has been answered by Barbara Boehmer on Feb 28 2017
Jump to Answer
Comments
Post Details
Added on Feb 28 2017
3 comments
1,975 views