You can work with an SQL scrapbook page in many of the same ways that you work with an SQL statement created through the New SQL Statement wizard. However, there are a few limitations. The following table summarizes the comparison of an SQL scrapbook page to an SQL statement that is created through the New SQL Statement wizard. For more detailed information, refer to the topic that describes the specific functionality.
Function | SQL scrapbook page | SQL statement created through wizard |
---|---|---|
Available tools | SQL editor | SQL builder and SQL editor |
SQL statement types | Data Definition Language (DDL) and Data Manipulation Language (DML) |
|
Create file |
|
|
Statement template provided | No | Yes, for DML statements |
Multiple SQL statements in one file | Yes |
|
Format of saved file | XML | Raw SQL |
Extension of saved file | .sqlpage | .sql |
Edit file | SQL editor: any development perspective, except Data |
|
Run file | From SQL editor |
|
Host variables in SQL statement | No |
|
Import SQL statement into stored procedure or user-defined function | No | Yes |