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

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"

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

Sales Offer

  • To avail this offer, enroll before 24th November 2017.
  • 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 banner Black friday

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