InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 05:40:31 GMT20http://www.sqlservercentral.com/Forums/Topic641675-1465-1.aspxTo be clearer, as you can name the primary key anything you want the statements from the article would miss any that do not begin with 'PK'.[code]declare @name_pk varchar(255)select @name_pk = name from sysindexes where id in (select id from sysobjects where name = 'table_name') and name like 'PK%'execute ('alter table table_name drop constraint ' + @name_pk)[/code]So to get the name of the Primary Key Constraint without this restriction, using the same 'table_name' substitution:[code]declare @name_pk varchar(255)SELECT @name_pk = constraint_name FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_type = 'PRIMARY KEY' and Table_name = 'table_name'Print 'pk ' + @name_pk -- show the results/* or use the execute as in the original */-- execute ('alter table table_name drop constraint ' + @name_pk)[/code]ToniThu, 29 Jan 2009 05:48:40 GMTtoniupstnyhttp://www.sqlservercentral.com/Forums/Topic641675-1465-1.aspxThis information can be gotten despite how the constraint is named this way:[code]SELECT Table_name, constraint_name FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_type = 'PRIMARY KEY'[/code]then you can use the table_name and constraint_name to do what you wish.ToniThu, 29 Jan 2009 05:29:41 GMTtoniupstnyhttp://www.sqlservercentral.com/Forums/Topic641675-1465-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Primary+key/65628/">how get primary key in any database</A>[/B]Thu, 22 Jan 2009 07:04:28 GMTFuranshizuku