戻る
-
タイトル
Is it possible to create a restore script automatically when issuing an ALTER statement? -
説明
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