ํŠน์ • ํ…Œ์ด๋ธ”์˜ ์ œ์•ฝ์‚ฌํ•ญ( not null, fk ๊ณผ ๊ฐ™์€ )์˜ ์ด๋ฆ„, ํ…Œ์ด๋ธ”๋ช…, ์†Œ์œ ์ž์˜ ๋ชฉ๋ก์„ ๋ณด์—ฌ์ค๋‹ˆ๋‹ค.

Below query command queries constraints'(not null, fk) name , owner, table name, column name, and position of the column.


SQL > select * from user_cons_columns where table_name='table_name';