/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

8 votes203 views1 answer
Declare table variable sql server
SQL
0 vote187 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote175 views1 answer
Sql getdate date only
SQL
5 votes186 views3 answers
Truncate function in sql oracle
SQL
0 vote173 views1 answer
Mysql start of today
SQL
14 votes198 views1 answer
Oracle new column
SQL
12 votes191 views1 answer
Docker run mysql image
SQL
1 vote224 views2 answers
Sql now - 1 day
SQL
1 vote187 views1 answer
OstgreSQL version
SQL
0 vote205 views1 answer
Replace string in whole database mysql stackoverflow
SQL