how to check if sequence exists in sql server

Fortune Mbulazi answered on October 6, 2022 Popularity 3/10 Helpfulness 4/10

answer how to check if sequence exists in sql server

how to check if sequence exists in sql server

Comment

//Check if the sequence exist before creating it.
IF NOT EXISTS(SELECT * FROM sys.sequences WHERE name = 'sequence_name')
BEGIN
	CREATE SEQUENCE [dbo].[MySequence]
	AS BIGINT
    START WITH 100
	INCREMENT BY 1;
END

Popularity 3/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: exists sequence sql sql-server

Link to this answer
Share Copy Link

Contributed on Oct 06 2022

Fortune Mbulazi

0 Answers Avg Quality 2/10

how to check if sequence exists in sql server

Contents

More Related Answers

how to check if sequence exists in sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.