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
|