Answers for "count number of columns in table mysql query"

how to count number of columns in a table in mysql

-- Oracle
SELECT count(*) FROM ALL_TAB_COLUMNS WHERE OWNER='owner_name' 
	AND TABLE_NAME = 'table_name';
-- SQL Server / MySQL
SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'schema_name' 
	AND TABLE_NAME = 'table_name';

Posted by: Guest on July-04-2021

Code answers related to "count number of columns in table mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "count number of columns in table mysql query"

Code answers related to "count number of columns in table mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "count number of columns in table mysql query"

Code answers related to "count number of columns in table mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us