/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 votes130 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote181 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote131 views1 answer
Oracle service name view
SQL
0 vote127 views1 answer
Sql case when exists in another table
SQL
8 votes126 views3 answers
Mysql alter table add index
SQL
0 vote132 views1 answer
Add timestamp column to existing table ms sql server
SQL
14 votes139 views6 answers
Auto_increment mysql
SQL
0 vote205 views1 answer
Sql database size
SQL
0 vote146 views1 answer
Mysql enter ubuntu
SQL
3 votes145 views1 answer
Oracle revoke
SQL