Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Data Definition

Other SQL commands, classified as data definition language or DDL, perform data definition operations, such as creating or removing objects like tables, indexes, and views. This statement sets up a table called test with two columns: one called id that holds integers, and another called name that holds up to fifteen characters.

SQL

create table test
(id  int,
name char (15) )
[table created]

You can SELECT from the test table, even before it has any data in it:

SQL

select *
from test
         id name
=========== ===============

[0 rows]