reset-key.sql

来自「卡内基梅隆大学软件工程课件,很全面」· SQL 代码 · 共 23 行

DELETE FROM next_account_id;

INSERT INTO next_account_id 
   VALUES (1 +
   (SELECT MAX(CAST (account_id AS INTEGER))
    FROM account));

DELETE FROM next_customer_id;

INSERT INTO next_customer_id
   VALUES (1 +
   (SELECT MAX(CAST (customer_id AS INTEGER))
    FROM customer));

DELETE FROM next_tx_id;

INSERT INTO next_tx_id
   VALUES (1 +
   (SELECT MAX(CAST (tx_id AS INTEGER))
    FROM tx));

EXIT;