Statements in SQL

< SQL

Introduction
In the screenshot below you can see a SQL statement.



The structure of SQL statements vary. The number of lines used does not matter. A statement can be written all on one line, or split up across multiple lines if it makes it easier to read. In this course, you will become familiar with the structure of common statements.
 * Statements always end in a semiclolon ;.
 * CREATE TABLE is a clause or command. Clauses are written in capital letters. They perform specific tasks in SQL.
 * Table_name refers to the name of the table that the command is applied to.
 * (column_1 data_type, column_2 data_type, column_3 data_type) is a parameter. A parameter is a list of columns, data types, or values that are passed to a clause as an argument. Here, the parameter is a list of column names and the associated data type.