Displaying the constraints in a table

Try this:

SELECT constraint_name, 
       constraint_type,
       search_condition
  FROM USER_CONSTRAINTS
 WHERE table_name = 'TEAMS';

Unless double-quoted when created, all object names in Oracle are upper case.

select dbms_mview.get_ddl('TABLE',USER,'TEAMS') from dual;

Use the following code:

show create table table_name;

I personally use:

SELECT * FROM all_constraints WHERE Table_Name = <TableName>;

Related