I have about 600 database tables in my sql database. I have a column that needs to be removed but I don't know how many tables it was defined or referenced in. Is there a way to check how many tables a column is referenced in?
Asked
Active
Viewed 220 times
0
-
Use the dictionary table `information_schema.columns`! – jarlh May 08 '17 at 06:54
-
that should help you http://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name] – hopeless May 08 '17 at 07:07
-
Which DBMS are you using? Postgres? Oracle? ("SQL" is only a query language, not the name of a database product - all relational databases are "SQL databases") – May 08 '17 at 08:10