 | |
desc plus; something that shows constraints too?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
desc plus; something that shows constraints too? -
02-17-2008
, 05:15 PM
#2
| |||
| |||
|
|
Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? |
is PS/SQL package DBMS_METADATA and there are views like
USER_CONSTRAINTS.
Kind regards
robert
#3
| |||
| |||
|
|
Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? |
is PS/SQL package DBMS_METADATA and there are views like
USER_CONSTRAINTS.
Kind regards
robert
#4
| |||
| |||
|
|
Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? |
is PS/SQL package DBMS_METADATA and there are views like
USER_CONSTRAINTS.
Kind regards
robert
#5
| |||
| |||
|
|
Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? |
is PS/SQL package DBMS_METADATA and there are views like
USER_CONSTRAINTS.
Kind regards
robert
#6
| |||
| |||
|
|
On Feb 18, 12:15 am, danwal... (AT) yahoo (DOT) com wrote: Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? There are different ways depending on what you want to achieve. There is PS/SQL package DBMS_METADATA and there are views like USER_CONSTRAINTS. Kind regards robert |
database objects via the rdbms dictionary views. Here is a short
article on some of the most useful views:
How do I find information about a database object: table, index,
constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html
To answer your question the following query might be of interest:
select search_condition
from all_constraints
where table_name = 'xxxxx'
and owner = 'yyyy'
and constraint_type = 'C'
HTH -- Mark D Powell --
#7
| |||
| |||
|
|
On Feb 18, 12:15 am, danwal... (AT) yahoo (DOT) com wrote: Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? There are different ways depending on what you want to achieve. There is PS/SQL package DBMS_METADATA and there are views like USER_CONSTRAINTS. Kind regards robert |
database objects via the rdbms dictionary views. Here is a short
article on some of the most useful views:
How do I find information about a database object: table, index,
constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html
To answer your question the following query might be of interest:
select search_condition
from all_constraints
where table_name = 'xxxxx'
and owner = 'yyyy'
and constraint_type = 'C'
HTH -- Mark D Powell --
#8
| |||
| |||
|
|
On Feb 18, 12:15 am, danwal... (AT) yahoo (DOT) com wrote: Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? There are different ways depending on what you want to achieve. There is PS/SQL package DBMS_METADATA and there are views like USER_CONSTRAINTS. Kind regards robert |
database objects via the rdbms dictionary views. Here is a short
article on some of the most useful views:
How do I find information about a database object: table, index,
constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html
To answer your question the following query might be of interest:
select search_condition
from all_constraints
where table_name = 'xxxxx'
and owner = 'yyyy'
and constraint_type = 'C'
HTH -- Mark D Powell --
#9
| |||
| |||
|
|
On Feb 18, 12:15 am, danwal... (AT) yahoo (DOT) com wrote: Rookie here. Is there a sqlplus command, something like desc, that also lists column contraints? There are different ways depending on what you want to achieve. There is PS/SQL package DBMS_METADATA and there are views like USER_CONSTRAINTS. Kind regards robert |
database objects via the rdbms dictionary views. Here is a short
article on some of the most useful views:
How do I find information about a database object: table, index,
constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html
To answer your question the following query might be of interest:
select search_condition
from all_constraints
where table_name = 'xxxxx'
and owner = 'yyyy'
and constraint_type = 'C'
HTH -- Mark D Powell --
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.