|
While the idea of this procedure is of general nature, it is designed for internal use in AbaPerls. When you load a .seq file and the sequences already exists in the database and cannot be dropped because it is used as a default, or values have been taken from it, AbaPerls loads the sequence defintion in the file into a temporary schema and then uses this procedure to compare the sequences. If there are differences than can safely be addresses with ALTER SEQUENCE, these are performed, else there is a warning or an error message.
Parameters: @left nvarchar(255) - the sequnce in the temp schema. @right nvarchar(255) - the existing sequence in the database. |
|
|
|