bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!

Create & Drop Table

 

  • CREATE Table:

After creating a database we create a table to store the data. It includes table name, column name and its data types. The syntax is as follows:

Syntax:

CREATE TABLE TableName(

Column1 datatype(size),

Column2 datatype(size),

Column3 datatype(size),

….

….

ColumnN datatype(size)

);

Example:

If we want to create a table “Student details” which includes its Name, Roll No., Address, Email Id, Phone No.

CREATE TABLE Student_details (

Name varchar(30),

Roll_No varchar(10),

Address varchar(50),

Email_id varchar(20),

Phone_no int(10)

);

 

  • DROP Table:

It is used to delete a table from the database. The syntax is as follows:

Syntax:

DROP TABLE TableName;

Example:

DROP TABLE Student_details;

"0 Responses on Create & Drop Table"

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

top

Sales Offer

  • To avail this offer, enroll before 10th December 2016.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
offer-june

Sign Up or Login to view the Free Create & Drop Table.