87

CREATE Table

In MariaDB, CREATE TABLE statement is used to create table within a selected database.

Syntax:

You can also specify a column_name as primary_key which must be a NOT NULL.

Example:

Create a table “Students” within “tutoraspire” database.

---

Show tables

You can verify that whether the table is created by using SHOW TABLES command.

Output:

Here you can see the created table “students”.

See the table structure:

---

Another way to create table

Go to selected database and right click.

Click on table, you will see like this:

Create a table “Students”.

You can add other options like:

To add indexes:

To add Foreign Key:

Create code: