find primary key with table name

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. Received on Tue Jan 02 2007 - 03:32:04 CST