To follow the examples in this chapter, Sybase suggests that you start with a clean copy of the pubs2 or pubs3 database and return it to that state when you are finished. See a system administrator for help in getting a clean copy of either of these databases.
You can prevent any changes you make from becoming permanent by enclosing all the statements you enter inside a transaction, and then aborting the transaction when you are finished with this chapter. For example, start the transaction by typing:
begin tran modify_pubs2
This transaction is named modify_pubs2. You can cancel the transaction at any time and return the database to the condition it was in before you began the transaction by typing:
rollback tran modify_pubs2