Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL for retrieving Constraints
I am using Oracle for Windows 95 (Release 7.3.4), SQL Plus 3.3 and a test database. I would like to get table definitions and constraints using SQL. I tried the sp_helpconstraint system stored procedure, but it doesn't work. It is not recognized as valid. I would like to get the data types, constraints, defaults, rules, and triggers of any table, using SQL.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri May 12 2000 - 00:00:00 CDT
![]() |
![]() |