Re: desc plus; something that shows constraints too?
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 18 Feb 2008 00:07:09 -0800 (PST)
Message-ID: <50f70c40-64a1-47d2-b867-b5426977aa3c@41g2000hsc.googlegroups.com>
Date: Mon, 18 Feb 2008 00:07:09 -0800 (PST)
Message-ID: <50f70c40-64a1-47d2-b867-b5426977aa3c@41g2000hsc.googlegroups.com>
On Feb 18, 12:15 am, danwal..._at_yahoo.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 Received on Mon Feb 18 2008 - 02:07:09 CST