Create Table in Database

The objects in a Relational database System is called Tables. The Tables contain the information on data for the database.

Create Table in Database

Create Table in Database

     

The objects in a Relational database System is called Tables. The Tables contain the information on data for the database. Each Table in a database is uniquely identified  by their names. It comprised of columns and rows. The column in a table contain the name of column, data type and attribute incase used in column. Columns in a Table are also called Field. The Rows contains the set of records and data for the columns. Rows in a Table are  Tuple.The collection of rows and column collectively called  cell in a Table. 

Understand with Example

The Tutorial illustrates you a simple example for the beginners, to create a table in database. In this Tutorial, we are using MySQL command query to create a table in database name countryinfo.

The create database is used to create database name countryinfo.

The use is used to show  the database

The create table is used to create a table name country in database

The show table is used to display the table name in database. 

create database countryinfo;

Output is displayed as

Output is displayed as

  use countryinfo;

create table country(countryname varchar(15),countrycapital varchar(15));

 Output is displayed as

  show tables;

 Output is displayed as

Download Source