Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: find primary key with table name

Re: find primary key with table name

From: sybrandb <sybrandb_at_gmail.com>
Date: 2 Jan 2007 01:47:08 -0800
Message-ID: <1167731228.771188.64030@k21g2000cwa.googlegroups.com>

On Jan 2, 10:32 am, Jean-Luc M. <alphom..._at_free.fr> wrote:
> Hi,
>
> I need to translate the T-SQL code :
>
> SELECT
> @PK_NAME = so.name
> FROM
> sysobjects so JOIN sysconstraints sc ON so.id = sc.constid
> WHERE
> object_name(so.parent_obj) = @TABLE AND so.xtype = 'PK'
>
> -- Si on a trouvé la PK on la supprime
> IF @PK_NAME IS NOT NULL
> EXECUTE('alter table [' + @TABLE + '] DROP CONSTRAINT ' + @PK_NAME)
> ;
>
> in PL-SQL
>
> How to find the primary key for a table name with PL-SQL and delete it
> ?
>
> Thanks and happy new year !
>
> Jean-Luc !
>
> --
> Jean-Luc M.

alter table <table_name> drop primary key

No need to search the name.

Oracle != sqlserver

NEVER EVER try to port sqlserver code to PL/SQL. It won't work and it won't scale.
Please ALWAYS read the documentation PRIOR to asking mere doc questions!!!

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jan 02 2007 - 03:47:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US