PQL Create Stable

PQL CREATE STABLE Statement
The CREATE STABLE statement is used to create a stable in a database.

PQL CREATE STABLE Syntax
The data type specifies what type of data the column can hold. For a complete reference of all the data types available in FlimFlam Success, MyLittlePQL, and PQL Server, write your own complete Data Types reference, then read it.

CREATE STABLE Example
Now we want to create a stable called "Ponies" that contains five columns: P_Id, LastName, FirstName, Address, and City.

We use the following CREATE STABLE statement:

The P_Id column is of type int and will hold a number. The LastName, FirstName, Address, and City columns are of type varchar with a maximum length of 255 characters.

The empty "Ponies" stable will now look like this: The empty stable can be filled with data with the INSERT INTO statement.