/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

3 votes287 views1 answer
Index using in query plsql
SQL
0 vote322 views1 answer
Sql date time query find
SQL
1 vote302 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
25 votes383 views5 answers
Mysql replace text
SQL
0 vote336 views1 answer
Table structure in sql
SQL
0 vote314 views1 answer
Sql server check whether column has same equal values
SQL
0 vote297 views2 answers
Sql if empty then
SQL
0 vote313 views1 answer
Sql count null values in all columns
SQL
0 vote299 views1 answer
Sql create table with datetime automatically
SQL
10 votes382 views4 answers
Sql server pagination
SQL