github.com/mithrandie/csvq@v1.18.1/docs/_posts/2006-01-02-temporary-table.md (about)

     1  ---
     2  layout: default
     3  title: Temporary Table - Reference Manual - csvq
     4  category: reference
     5  ---
     6  
     7  # Temporary Table
     8  
     9  A Temporary Table that is treated as "VIEW" can be used in a procedure.
    10  You can refer, insert, update, or delete records in temporary tables.
    11  
    12  Temporary tables are affected by transactions.
    13  When current transaction is rolled back, the records that saved at the previous commit are restored. 
    14  
    15  ## Declare Temporary Table
    16  {: #declare}
    17  
    18  ### Declare Empty Table
    19  
    20  ```sql
    21  DECLARE table_name VIEW (column_name [, column_name ...]);
    22  ```
    23  
    24  _table_name_
    25  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})
    26  
    27  _column_name_
    28  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})
    29  
    30  
    31  ### Declare from the Result-Set of a Select Query
    32  
    33  ```sql
    34  DECLARE table_name VIEW [(column_name [, column_name ...])] AS select_query;
    35  ```
    36  
    37  _table_name_
    38  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})
    39  
    40  _column_name_
    41  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})
    42  
    43  _select_query_
    44  : [Select Query]({{ '/reference/select-query.html' | relative_url }})
    45  
    46  
    47  ## Dispose Temporary Table
    48  {: #dispose}
    49  
    50  ```sql
    51  DISPOSE VIEW table_name;
    52  ```
    53  
    54  _table_name_
    55  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})