有关缓存的行为的详细信息,请参阅CREATE SEQUENCE (Transact-SQL)。 备注 有关如何创建序列以及如何管理序列缓存的信息,请参阅CREATE SEQUENCE (Transact-SQL)。 不能将表示升序的 MINVALUE 和表示降序的 MAXVALUE 更改为不允许序列的 START WITH 值的值。 如果要将升序的 MINVALUE 更改为一个大于 START WITH 值...
[WITH VALUES], end_transaction_id_column_name bigint GENERATED ALWAYS AS TRANSACTION_ID END [ HIDDEN ] NULL [ CONSTRAINT constraint_name ] DEFAULT constant_expression [WITH VALUES], start_sequence_number_column_name bigint GENERATED ALWAYS AS SEQUENCE_NUMBER START [ HIDDEN ] NOT NULL [ ...
[WITH VALUES], end_transaction_id_column_name bigint GENERATED ALWAYS AS TRANSACTION_ID END [ HIDDEN ] NULL [ CONSTRAINT constraint_name ] DEFAULT constant_expression [WITH VALUES], start_sequence_number_column_name bigint GENERATED ALWAYS AS SEQUENCE_NUMBER START [ HIDDEN ] NOT NULL [ ...
SQL Server Azure SQL 数据库 Azure SQL 托管实例 将Transact-SQL 和查询处理行为设置为与指定的 SQL 引擎版本兼容。 有关其他 ALTER DATABASE 选项,请参阅ALTER DATABASE。 有关语法约定的详细信息,请参阅Transact-SQL 语法约定。 语法 syntaxsql复制
Starting with SQL Server 2005 (9.x)Data 1 MB. Log files 10%. Prior to SQL Server 2005 (9.x)Data 10%. Log files 10%. Note FILEGROWTHcannot be set: When a UNC path is specified for the file ForFILESTREAMandMEMORY_OPTIMIZED_DATAfilegroups ...
CreateSequenceStatement CreateServerAuditSpecificationStatement CreateServerAuditStatement CreateServerRoleStatement CreateServiceStatement CreateSpatialIndexStatement CreateStatisticsStatement CreateSymmetricKeyStatement CreateSynonymStatement CreateTableStatement CreateTriggerStatement CreateTypeStatement CreateTypeTableStatement ...
sequence-name Identifies the sequence that is to be changed. The name, including the implicit or explicit schema qualifier, must uniquely identify an existing sequence at the current server. If no sequence by this name exists in the explicitly or implicitly specified schema, an error (SQLSTATE ...
Identifies the sequence to be altered. The name must identify a sequence that already exists at the current server. DATA TYPEdata-type Specifies the new data type to be used for the sequence value. The data type can be any exact numeric type (SMALLINT, INTEGER, BIGINT, DECIMAL, or NUMERI...
SQL Statements: ALTER CLUSTER to ALTER SEQUENCE, 6 of 18ALTER INDEX Purpose Use the ALTER INDEX statement to change or rebuild an existing index. See Also: CREATE INDEX for information on creating an index Prerequisites The index must be in your own schema or you must have ALTER ...
To restart the sequence at a different number, you must drop and re-create it. If you change theINCREMENTBYvalue before the first invocation ofNEXTVAL, some sequence numbers will be skipped. Therefore, if you want to retain the originalSTARTWITHvalue, you must drop the sequence and re-create...