The following table contains SQL Server database operations and their display names that appear in the fine-tuning database restore dialog.
Entity | Operation | Display Format | Constraints |
|---|---|---|---|
Table | CREATE | <date_time> Created[/Modified] <table_name> Table <table ID> <initiator> |
|
DROP | <date_time> Deleted <table_name> Table <table ID> <initiator> |
| |
ALTER | <date_time> Column added <table_name> Table <table ID> <initiator> |
| |
INSERT INTO | <date_time> Inserted row <table_name>[/table_ID] Table <initiator> | Table name will not be displayed for deleted table, only table ID will be shown. | |
DELETE FROM | <date_time> Deleted row <table_name>[/table_ID] Table <initiator> | Table name will not be displayed for deleted table, only table ID will be shown. | |
UPDATE | <date_time> Modified <table_name>>[/table_ID] Table <initiator> | Table name will not be displayed for deleted table, only table ID will be shown. | |
TRUNCATE | <date_time> Truncated Table <initiator> | Table name and ID will not be displayed for deleted table. | |
BULK INSERT | <date_time> Inserted row <table_name>[/table_ID] Table <initiator> |
| |
View | CREATE | <date_time> Created <view_name> View <initiator> |
|
DROP | <date_time> Deleted <view_name> Table <initiator> |
| |
ALTER | <date_time> Modified <view_name> View <initiator> |
| |
Index | CREATE | <date_time> Created <index_name> Index <initiator> |
|
DROP | <date_time> Deleted <index_name> Index <initiator> |
| |
ALTER | <date_time> Modified <index_name> Index <initiator> |
| |
Procedure | CREATE | <date_time> Created <procedure_name> Procedure <initiator> |
|
DROP | <date_time> Deleted <procedure_name> Table <initiator> |
| |
ALTER | <date_time> Modified <procedure_name> Procedure <initiator> |
| |
Function | CREATE | <date_time> Created <function_name> Function <initiator> |
|
DROP | <date_time> Deleted <function_name> Table <initiator> |
| |
ALTER | <date_time> Modified <function_name> Function <initiator> |
| |
Schema | CREATE | <date_time> Created <schema_name> Schema <initiator> |
|
DROP | <date_time> Deleted <schema_name> Schema <initiator> |
| |
ALTER | <date_time> Modified <schema_name> Schema <initiator> | Schema cannot be detected. | |
User | CREATE | <date_time> Created <user_name> User <initiator> |
|
DROP | <date_time> Deleted <user_name> User <initiator> |
| |
ALTER | <date_time> Modified <user_name> User <initiator> |
| |
Trigger | CREATE | <date_time> Created <trigger_name> Trigger <initiator> |
|
DROP | <date_time> Deleted <trigger_name> Trigger <initiator> |
| |
ALTER | <date_time> Modified <trigger_name> Trigger <initiator> |
|
