lernoutmaltas's picture
Nov 21, 2013
4619 views
Reputation: 130

Deleting only customers from the database, using detran.sqlce.

Tags: 

I did once, but I remember more how to proceed.

I do not know how to formulate the condition.

DELETE FROM [Entities]
WHERE <Search Conditions,,>;
GO

1 answers

lemmings's picture
lemmings
Nov 22, 2013
Reputation: 15

If you just want to delete customers you could use the query

DELETE FROM [Entities]

WHERE [EntityTypeId] = 1  (standard setup Customers where set to 1)

We have already answers to
1030 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634