/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

10 votes244 views6 answers
Sql between
SQL
1 vote250 views1 answer
Sql restore backup query
SQL
0 vote227 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote252 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
14 votes255 views6 answers
Auto_increment mysql
SQL
0 vote262 views1 answer
Cannot pip install mysqlclient
SQL
0 vote228 views1 answer
Oracle search columns in schema
SQL
1 vote237 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
2 votes240 views1 answer
Removing view
SQL
0 vote251 views2 answers
Raise notice in postgresql function
SQL