SQL Server Database Operations

In this article

    The following table lists SQL Server database operations and their corresponding 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>