SQL Server Database Operations
The following table lists SQL Server database operations and their display names that appear in the fine-tune 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> |
— |