In the documentation of
CREATE SEQUENCE for T-SQL, you can see that the
CREATE SEQUENCE command has no
For comparison, the Oracle docs for
CREATE SEQUENCE show the
ORDERto guarantee that sequence numbers are generated in order of request. This clause is useful if you are using the sequence numbers as timestamps. Guaranteeing order is usually not important for sequences used to generate primary keys.
ORDERis necessary only to guarantee ordered generation if you are using Oracle Database with Real Application Clusters. If you are using exclusive mode, sequence numbers are always generated in order.
NOORDERif you do not want to guarantee sequence numbers are generated in order of request. This is the default.
Does Microsoft SQL Server provide a strong ordering constraint for
SEQUENCEs? Or does Microsoft not consider it important in general?