Data Manipulation

SQL Create Database, Table,

Create a Database

To create a database:

Create a Table

To create a table in a database:

Example

This example demonstrates how you can create a table named "Person", with four columns. The column names will be "LastName", "FirstName", "Address", and "Age":

This example demonstrates how you can specify a maximum length for some columns:

The data type specifies what type of data the column can hold. The table below contains the most common data types in SQL: