开发者

How can I find the columns of a disabled index constraint?

开发者 https://www.devze.com 2022-12-27 07:43 出处:网络
For a normal index constraint, you can find the columns it is on by querying the all_ind_columns sysview using the index name in all_constraints. But if the constraint is disabled, no index exists, an

For a normal index constraint, you can find the columns it is on by querying the all_ind_columns sysview using the index name in all_constraints. But if the constraint is disabled, no index exists, and there doesn't seem开发者_如何学编程 to be anywhere else that has constraint column information. How can I get the columns of a disabled index constraint from the data dictionary (without re-enabling the constraint)?


What about ALL_CONS_COLUMMS? Seems to work find for disabled constraints of types U and P.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号