Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
How do I find all the tables in a database that don't have a specific column?
+0
−2
I need to add one column with the same name to all of the tables in my database, how can I find which tables don't currently have a column with that name?
1 answer
+1
−0
The select for finding tables without a specific column name is,
SELECT DISTINCT table_name
FROM information_schema.tables
WHERE table_schema = 'DATABASE_NAME'
AND table_name NOT IN(
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME ='COLUMN_NAME'
AND TABLE_SCHEMA='DATABASE_NAME'
);
0 comment threads
0 comment threads