/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

0 vote124 views1 answer
Pgsql is not permitted to log in
SQL
0 vote121 views1 answer
Mysql calculated column
SQL
0 vote248 views1 answer
How to delete duplicate rows in oracle
SQL
2 votes120 views2 answers
Change varchar length mysql
SQL
-2 votes131 views2 answers
Sqlserver docker
SQL
0 vote147 views1 answer
Postgres get database encoding
SQL
0 vote124 views1 answer
Mysql user set plugin
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
1 vote135 views1 answer
Postgres count string length
SQL
7 votes127 views1 answer
Sql management studio display line numbers
SQL