/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 votes191 views3 answers
Postgresql connection string c#
SQL
0 vote213 views1 answer
Psql show db
SQL
7 votes237 views1 answer
Show line number in sql server
SQL
1 vote200 views1 answer
How to change owner in postgres
SQL
0 vote234 views2 answers
Suse Linux restart MySQL
SQL
0 vote209 views1 answer
Get cpu details sql
SQL
0 vote311 views1 answer
Delet all record statment sql
SQL
5 votes214 views1 answer
Oracle list days between two dates
SQL
8 votes263 views1 answer
Database backup in mysql server recovery
SQL
0 vote188 views1 answer
Java spring boot connect to sql server
SQL