Then Simply add one. I think: The row you are deleting should be identified uniquely. Which means if any other row exists in the table which contains the same data (i.e. you cannot distinguish the 2 rows) then delete operation may NOT occur.
By the way how and from where you are trying to delete? On Feb 16, 8:40 pm, Jon Liu <[email protected]> wrote: > There was, but when I had a problem inserting because the primaries were all > the same( i know..) so I unmarked the primary. So to answer your question, > no there is no longer a primary key... > > > > On Sun, Feb 15, 2009 at 10:17 PM, Arsalan Tamiz <[email protected]> wrote: > > Is there any primary key in the Table? > > > On Sun, Feb 15, 2009 at 11:55 PM, BigJ <[email protected]> wrote: > > >> I nserted some bad data into my table and want to remove it...when I > >> try to delete the bad data this is the prompt that I recieve: > > >> Deleting data from existing tables: > >> No rows were deleted > > >> A problem occurred attempting to delte row 4. > >> Error Source: Microsoft.visualStudio.DataTools. > >> Error Message: The row value(s) updated or deleted either do not make > >> the row unique or they alter multiple rows(6 rows) > > >> Correct the errors and attempt to delete the row again or press @SC to > >> cancel the change(s). > > >> Any thoughts? > > >> Thanks > > >> Jon- Hide quoted text - > > - Show quoted text -
