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.
Post History
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 DI...
Answer
#2: Post edited
by
Charlie Brumbaugh
·
2020-09-11T15:26:26Z (about 4 years ago)
The select for this 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'- );
- ```
- 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'
- );
- ```
#1: Initial revision
by
Charlie Brumbaugh
·
2020-09-11T15:25:42Z (about 4 years ago)
The select for this 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'
);
```