/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 vote277 views1 answer
Rollback to name in sql
SQL
21 votes286 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote320 views1 answer
What is delimiter in mysql
SQL
1 vote297 views2 answers
Sql server add time to date
SQL
0 vote276 views3 answers
Get free card roblox
SQL
0 vote254 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote291 views1 answer
Oracle temporary table
SQL
0 vote276 views4 answers
Sql year
SQL
0 vote267 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote300 views1 answer
How to create a table based on another table in mysql
SQL