Supported Databases
Database Tour can work with database sequences in Oracle, PostgreSQL, Firebird, Interbase databases.
Notes
- The current database user must have the corresponding permissions to work with these objects.
- In Firebird and Interbase, sequences are named as generators.
To work with database sequences, use the corresponding tab of the Object Browser.
Creating Database Sequences
To create a sequence from scratch, click New button 
of the Object Browser. The new SQL editor will be opened with the skeleton of the sequence SQL code. Complete the code and click Execute button 
. If necessary, read the documentation for your database.
Note: After executing your SQL code, if your database is not Oracle and you work in the no auto-commit mode, finish the transaction by clicking Commit button.
Deleting Database Sequences
To delete (drop) a sequence, select the needed object in the list of sequences and click Delete button.
To delete several sequences, right-click the list and choose Multiple Selection. Then select needed sequences and click Delete button.
Hint: Sequences can also be deleted by the corresponding SQL command.
Opening Existing Database Sequences
Switch to the corresponding tab of the Object Browser. Locate the needed sequence and select it. This will open a new sub-window displaying the object's properties. Switch to the Script tab to view the DDL code.
Hint: If you double-click the object name in the list, the sub-window will be opened with the Script tab activated.
Editing Existing Database Sequences
Open the needed object (see above) and switch to the Script tab. Then click Copy to Editor button 
. The new SQL editor will be opened with the DDL code of the object. Modify it accordingly and click Execute button .
Another way (without coding) to edit the object is to use the Utilities button 
on the General tab.