I think it's because you are selecting "distinct" column_name. The query will return only one value and will ignore all the other values it returned. If you get rid of distinct, you will get all tablenames and columns for those tables.


Also, according to your sql statement, you included user_constraints are not using the user_constraints table.