Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
SBailey (WMF)
.
Query to report the number linter errors associated with a template - number of pages referencing it with an error and total errors associated with the template
Toggle Highlighting
SQL
select c.table_schema as database_name, c.table_name, c.column_name, case c.is_nullable when 'NO' then 'not nullable' when 'YES' then 'is nullable' end as nullable from information_schema.columns c join information_schema.tables t on c.table_schema = t.table_schema and c.table_name = t.table_name where c.table_schema not in ('mysql', 'sys', 'information_schema', 'performance_schema') and t.table_type = 'BASE TABLE' -- and t.table_schema = 'database_name' -- put your database name here order by t.table_schema, t.table_name, c.column_name;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...