View records using a SQL script
Complete the tutorial setup.
Click the SQL Scripts tab (
).Enter the following SQL query:
SELECT * from athlete;
Note
The SQL Scripts tab can run multiple SQL statements. Typically these statements create objects and insert, update, and delete records.
Sometimes scripts query records.
Because the SQL Scripts tab can run multiple SQL statements, each statement must be followed by a semicolon. In contrast, the SQL Queries tab (
) can only run one SQL query at a time; thus, queries in the SQL Queries tab do not need a semicolon at the end.
Click Run All (
).Tip
The SQL Scripts tab returns results as text which is useful for queries when you want to copy query results into another program. However, It is less friendly than the SQL Queries tab, which returns results in a formatted table.
You can select one SQL statement, out of many, and click the button (
) to execute the statement.