Get All Columns in MySQL

Get all Column of a specific Tables in MySQL.

SELECT

table_name as 'Table Name',

column_name as 'Column Name'

FROM

information_schema.COLUMNS

WHERE

table_schema = '$DATABASE_NAME';

AND table_name = '$TABLE_NAME';

SELECT table_name as 'Table Name', column_name as 'Column Name' FROM information_schema.COLUMNS WHERE table_schema = '

D A T A B A S E_{N} A M E^{'}; A N D t a b l e_{n} a m e =^{'}

$DATABASE_NAME'; AND table_name = '$ TABLE_NAME';

SELECT 
    table_name as 'Table Name',
    column_name as 'Column Name'
FROM 
    information_schema.COLUMNS
WHERE 
    table_schema = '$DATABASE_NAME';
    AND table_name = '$TABLE_NAME';

Get all Column of some Tables in MySQL.

SELECT

table_name as 'Table Name',

column_name as 'Column Name'

FROM

information_schema.COLUMNS

WHERE

table_schema = '$DATABASE_NAME';

AND table_name in ('

T A B L E_{N} A M E 1^{'},^{'}

$TABLE_NAME1', '$ TABLE_NAME2', '$TABLE_NAMEn');

SELECT table_name as 'Table Name', column_name as 'Column Name' FROM information_schema.COLUMNS WHERE table_schema = '

D A T A B A S E_{N} A M E^{'}; A N D t a b l e_{n} a m e i n (^{'}

$DATABASE_NAME'; AND table_name in ('$ TABLE_NAME1', '

T A B L E_{N} A M E 2^{'},^{'}

$TABLE_NAME2', '$ TABLE_NAMEn');

SELECT 
    table_name as 'Table Name',
    column_name as 'Column Name'
FROM 
    information_schema.COLUMNS
WHERE 
    table_schema = '$DATABASE_NAME';
    AND table_name in ('$TABLE_NAME1', '$TABLE_NAME2', '$TABLE_NAMEn');

Get all Columns of a specific schema in MySQL.

SELECT

table_name as 'Table Name',

column_name as 'Column Name'

FROM

information_schema.COLUMNS

WHERE

table_schema = '$DATABASE_NAME';

SELECT table_name as 'Table Name', column_name as 'Column Name' FROM information_schema.COLUMNS WHERE table_schema = '$DATABASE_NAME';

SELECT 
    table_name as 'Table Name',
    column_name as 'Column Name'
FROM 
    information_schema.COLUMNS
WHERE 
    table_schema = '$DATABASE_NAME';

Get all Columns of all schemas in MySQL.

SELECT

table_name as 'Table Name',

column_name as 'Column Name'

FROM

information_schema.COLUMNS;

SELECT table_name as 'Table Name', column_name as 'Column Name' FROM information_schema.COLUMNS;

SELECT 
    table_name as 'Table Name',
    column_name as 'Column Name'
FROM 
    information_schema.COLUMNS;