information_schema - Count all columns from all tables

Databases
1

Is there a way to Count all columns from all tables on one database, using the information_schema database ?

Thanks,

Dying,
Márcio

2

MySQL?

SELECT COUNT(*) FROM COLUMNS WHERE table_schema = 'dbname'
3

Thanks a lot, I look but I didn’t see the COLUMN table existence on information_schema database.

The code provided would return a “no database found error” I believe, but this one will do it:


SELECT COUNT(*) FROM information_schema.COLUMNS WHERE table_schema = 'your_database_name';

Thanks a lot,
Márcio