|
|
|
|
|
DBArtisan 4.01 1 2 3 4 5 6 7 8 9 10 Table editing is also greatly simplified. With SQL Server, you can always add a column. But it can only be added to the end of a table and must allow nulls. What if you want to add a column into the middle of a table, make it not null, or remove a column from a table? The only way to accomplish this is by the DBA performing an extended alter. This process is basically as follows:1. Rename the original table 2. Recreate the table with all of the new settings 3. Insert the data into the new table from the old table 4. Recreate all indexes and triggers 5. Set all stored procedures that use this table to recompile 6. Drop the old table This operation can be very tedious and time consuming. If you happen to forget something, you have problems. DBArtisan has the capability to perform this extended alter for you. Simply modify the table as you need it and select alter. DBArtisan then gives you the option of letting it perform the alter or creating a SQL script for you that does this.
One very nice feature is that every operation that is performed against the database is logged to a logging window at the bottom of the interface with color coded statements that allow you to easily pick out those that failed. This gives a very nice audit log for batches. DBArtisan also requires confirmation of every action you are going to perform. If it is a destructive action, you are asked to confirm that you really want to do this. If it is a creation operation, you are shown the SQL that will be executed. In either case, you have the option of canceling the operation. This helps eliminate the whoops! I didn't really mean to destroy that database by making the interface much safer to use than Enterprise Manager. |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
