sqlserver-序列

• 用途:跟identity是一个意思区别是identity只能用于一个table,序列可以应用于多个表
• 格式

  CREATE SEQUENCE [schema_name . ] sequence_name  
      [ AS [ built_in_integer_type | user-defined_integer_type ] ]  
      [ START WITH <constant> ]  
      [ INCREMENT BY <constant> ]  
      [ { MINVALUE [ <constant> ] } | { NO MINVALUE } ]  
      [ { MAXVALUE [ <constant> ] } | { NO MAXVALUE } ]  
      [ CYCLE | { NO CYCLE } ]  
      [ { CACHE [ <constant> ] } | { NO CACHE } ]  
      [ ; ]

  https://www.cnblogs.com/zhaoshujie/p/10146138.html