Answers for "how to delete records in table with no primary key"

SQL
1

remove primary key from a table

alter table Player DROP PRIMARY KEY;
Posted by: Guest on November-04-2020
0

sql server remove primary key without dropping table

IF EXISTS (SELECT * FROM sys.key_constraints
           WHERE type = 'PK' AND parent_object_id = OBJECT_ID('MyTable')
           AND Name = 'PK_MyTable')
    ALTER TABLE MyTable DROP CONSTRAINT PK_MyTable
Posted by: Guest on September-15-2021

Code answers related to "how to delete records in table with no primary key"

Code answers related to "SQL"

Browse Popular Code Answers by Language