I created 75k serail number by mistake.How i delet it. May I get full script ?
Delet serial number
Oct 29, 2007
1 Replies
Hi Gill - backup first and if possible try after hours....
Run this first select * from serial where transactionentryid = 0
If that shows you the 75 thousand serial numbers you created by mistake delete them with delete from serial where transactionentryid = 0
If the first select query shows more than the 75 thousand serial numbers you created by mistake, you'll need additional constraints to narrow down the list - hope this helps
"Gill" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required