Skip to content
Advertisement

Retrieve definition of Sequence object in SQL Server

How can I get the definition of any Sequence objects in SQL Server? For instance if I want to get the definition of View/Function/Procedure I would use below query

Please let me know if we have similar options available to get the details for Sequence objects

Advertisement

Answer

A SEQUENCE doesn’t have the same type of definition as an object like a VIEW or PROCEDURE, however, you could generate your own:

If this is so you have a repository of all your definitions, that should already be in your Source Control Software.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement