/SQL/Find how many table doesn't contain column in mysql

Find how many table doesn't contain column in mysql

select
t.*
from INFORMATION_SCHEMA.TABLES as t
    left join INFORMATION_SCHEMA.COLUMNS as c
    on c.TABLE_NAME = t.TABLE_NAME
    and c.TABLE_SCHEMA = t.TABLE_SCHEMA
    and c.COLUMN_NAME = 'unique'
where c.COLUMN_NAME is null
and t.TABLE_SCHEMA = 'database'

Source: stackoverflow.com

Similar codes

2 votes146 views1 answer
Orcale index size
SQL
-2 votes127 views1 answer
Mysql not empty
SQL
0 vote102 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote111 views1 answer
Check if database exists sql
SQL
4 votes105 views2 answers
Mysql show indexes on table
SQL
7 votes233 views2 answers
Drop index oracle
SQL
5 votes101 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote110 views1 answer
Mysql conf.d exampel
SQL
0 vote106 views1 answer
How to get inserted id in sql server
SQL
1 vote119 views2 answers
Oracle leftmost characters
SQL