The objects in a Relational database System is called Tables. The Tables contain the information on data for the 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

Related Tags for Create Table in Database:
c,  database,  com,  ide,  orm,  table,  data,  form,  object,  io,  objects,  tables,  sed,  format,  column,  system,  unique,  name,  columns,  relational,  id,  ai,  tab,  row,  if,  for,  rows,  ie,  call,  base,  each,  information,  names,  ws,  e,  it,  in,  rm,  info,  cal,  as,  m,  nt,  relation,  ca,  j,  es,  em,  ase,  all,  me,  obj,  sys,  rel,  umn,  uniq,  s,  col,  at,  is,  ir,  inf,  ll,  ea,  and,  s,  s,  ri,  th,  compris,  st,  ab,  abl,  ati,  cts,  lum,  inform,  informat,  je,  ident,  ident,  pr,  nd,  on,  om,  ol,  o

More Tutorials from this section

• Create Table in Database
• Delete a Records in Database
• Drop Table in Database
• SQL Tutorials for Beginner
• Insert Records in Table
• Select data from Table in Database
• SQL for Beginner
• SQL Introduction
• Update Records in Database
• Where Clause in SQL
• how to create database and table using jsp
• MySQL Create Table
• how to create a table
• Mysql Create Table
• JDBC: Create Table Example
• Create Table in Database
• Create a database
• Create Database SQLite
• Create Dynamic Table using Hubernate
• PHP How to Create Table