sequence's name

[PatMac]

Hi,

Is there a way to get the name of a sequence (or to force it when
creating the table) for an identity column? When we create a table
with an identity column, the sequence gets a unique name that cannot
be discovered it seems.

Thanks,

[Thomas Mueller]

Hi,

CREATE SEQUENCE TESTSEQ;
CREATE TABLE TEST(ID INT DEFAULT NEXT VALUE FOR TESTSEQ PRIMARY KEY);

There is a way to get the sequence name, but it is complicated.
Basically you need to parse COLUMN_DEFAULT in:
SELECT TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT FROM
INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_DEFAULT IS NOT NULL;

Regards,
Thomas

[PatMac]

Hi Thomas,

I had already looked to parse... but as you said, it is complicated. I
will use the first option. Thanks.

Patrice

On 23 oct, 00:11, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote: