Return
-
Title
Is it possible to create a restore script automatically when issuing an ALTER statement? -
Description
Is there the ability in Toad for SQL Server to have a restore script created automatically when an ALTER <database_object> statement is issued? This functionality is already available in Toad for DB2.
This is useful in particular for the lack of the Change Director which is no longer available.As an example:1. Open Object Explorer
2. Expand Database | Tables entry3. Right-click <table_name>
4. Select ALTER <table_name>
5. Make any changes to table (i.e.: add a column to table)
6. Click SQL ScriptExpected results:Restore script with DROP/CREATE table statement is generated automatically
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.