CREATE TableIn 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 "Javatpoint" database. ![]() Show tablesYou 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 tableGo 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: ![]()
Next TopicMariaDB Drop Table
|