FuzzDuck
FuzzDuck
Create table
FuzzDuck
Create table

Create table

The infrastructure of a database consists of tables. To create these tables, we give the command CREATE TABLE followed by the name of the table, and the following columns / parameters, the table consist of. Say, if we want to create a table named “Ducks”, and three columns named DuckNumber, and DuckName, we call the command CREATE TABLE Ducks { DuckNumber int, DuckName varchar (100) };. Now we have a table called Ducks, with the columns DuckNumber and DuckName.

--- SQL command to create table ---
CREATE TABLE tableName (column1Name column1Type, column2Name column2Type, …);
--- SQL command to create a table named Ducks, containing DuckNumber & DuckName ---
CREATE TABLE Ducks (DuckNumber int, DuckName varchar (100));