匿名投稿
投稿指南
RSS订阅Access自增字段的起始值和步进值
也就是说OrderId将从1000开始，每次递增10.
CREATE TABLE testBighead(
OrderId AUTOINCREMENT (1000, 10),
ItemId LONG, Quantity LONG) ALTER TABLE testBighead
ALTER COLUMN OrderId COUNTER (2000, 50) ALTER TABLE testBighead
ALTER COLUMN OrderId COUNTER (1, 1) 
- 