Using a SHOW statement in a subquery

I want to write an SQL statement that returns ONLY the column names for a given table. "SHOW COLUMNS FROM `table_name`;" Shows the data I want (and more). In order to get the data I need, every column from this statement must be removed except the `Field` column.

I have tried using a subquery with SELECT, but keep getting a syntax error. "SELECT `Field` FROM (SHOW COLUMNS FROM `table_name`)" Any ideas how to accomplish this?

↑ SHOW ↑

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ SHOW ↑
About SHOW
Extended Show
SHOW AUTHORS
SHOW BINARY LOGS
SHOW BINLOG EVENTS
SHOW CHARACTER SET
SHOW CLIENT_STATISTICS
SHOW COLLATION
SHOW COLUMNS
SHOW CONTRIBUTORS
SHOW CREATE DATABASE
SHOW CREATE EVENT
SHOW CREATE FUNCTION
SHOW CREATE PACKAGE
SHOW CREATE PACKAGE BODY
SHOW CREATE PROCEDURE
SHOW CREATE SEQUENCE
SHOW CREATE TABLE
SHOW CREATE TRIGGER
SHOW CREATE USER
SHOW CREATE VIEW
SHOW DATABASES
SHOW ENGINE
SHOW ENGINE INNODB STATUS
SHOW ENGINES
SHOW ERRORS
SHOW EVENTS
SHOW EXPLAIN
SHOW FUNCTION CODE
SHOW FUNCTION STATUS
SHOW GRANTS
SHOW INDEX
SHOW INDEX_STATISTICS
SHOW INNODB STATUS (removed)
SHOW LOCALES
SHOW MASTER STATUS
SHOW OPEN TABLES
SHOW PACKAGE BODY STATUS
SHOW PACKAGE STATUS
SHOW PLUGINS
SHOW PLUGINS SONAME
SHOW PRIVILEGES
SHOW PROCEDURE CODE
SHOW PROCEDURE STATUS
SHOW PROCESSLIST
SHOW PROFILE
SHOW PROFILES
SHOW QUERY_RESPONSE_TIME
SHOW RELAYLOG EVENTS
SHOW SLAVE HOSTS
SHOW SLAVE STATUS
SHOW STATUS
SHOW TABLE STATUS
SHOW TABLES
SHOW TABLE_STATISTICS
SHOW TRIGGERS
SHOW USER_STATISTICS
SHOW VARIABLES
SHOW WARNINGS
SHOW WSREP_MEMBERSHIP
SHOW WSREP_STATUS