Why does Azure SQL Database and MS SQL Server documentation say sequences are type sysname when they can be configured as anything?

Question

I was looking at the examples and types while seeing how to use the SEQUENCE command in T-SQL (Azure SQL Database, SQL Server, etc.), but when it lists the types SEQUENCE can be configured as (INT, BIGINT, TINYINT, etc.), it mentions that its "type is sysname".

I know what sysname is (for the most part), but isn't SEQUENCE the type I specify (INT, BIGINT, etc.), and not sysname?

What am I missing? I feel like I'm missing something crucial to my understanding of all this.

Thanks. Sorry for the newbie question -- I know I am one right now.

Here is the page I'm speaking of: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-ver15

The **NAME** of the `SEQUENCE` is of type `sysname` - not the values the `SEQUENCE` will return ..... (those are integer types) — marc_s, Oct 19 '19 at 06:57
From the docs: *sequence_name* - Specifies the unique name by which the sequence is known in the database. Type is **sysname**. — marc_s, Oct 19 '19 at 07:10
It's actually BIGINT (not INT) data type, but I get what you're saying. Noted. — Netside, Oct 19 '19 at 09:01

score 1 · Accepted Answer · answered Oct 21 '19 at 05:54

1

As marc_s said: The NAME of the SEQUENCE is of type sysname.

let me summarize:

sequence_name: Specifies the unique name by which the sequence is known in the database. Type is sysname. Not the data type.
The bigint the default data type of sequence if you don't set it.

Please don't mix the name type and the data type.

You can reference this documents:

Hope this helps.

answered Oct 21 '19 at 05:54

Leon Yue

15,693
1
11
23

Funny how things seem alien until we understand them and then they seem easy ;) – Netside Oct 28 '19 at 05:56

Why does Azure SQL Database and MS SQL Server documentation say sequences are type sysname when they can be configured as anything?

1 Answers1