Scribd
Upload
28 views20 pages

Presentation 1: Important SQL Commands Assignment 3 & Unit Instructor: Asst. Prof. K.S.Khandelwal

This presentation discusses important SQL commands for creating and managing databases and tables. It covers how to create a database and switch between databases. It explains how to create tables and view their structure. The presentation also demonstrates how to add, modify, and drop columns in tables. It provides the SQL syntax for these commands and shows sample outputs.

Uploaded by

guddu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
28 views20 pages

Presentation 1: Important SQL Commands Assignment 3 & Unit Instructor: Asst. Prof. K.S.Khandelwal

This presentation discusses important SQL commands for creating and managing databases and tables. It covers how to create a database and switch between databases. It explains how to create tables and view their structure. The presentation also demonstrates how to add, modify, and drop columns in tables. It provides the SQL syntax for these commands and shows sample outputs.

Uploaded by

guddu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 20

Presentation 1

Important SQL Commands


Assignment 3 & Unit
Instructor: Asst. Prof.
K.S.Khandelwal
Agenda of this presentation
Create Database & use Database
Create Database & use Database

Creates Database

Database is created

Show databse

Database available
Changing database

To change database

Database changed to college


Create Table & Describe Table
Create Table & Describe Table

Enter this command to view


database

Output for our database


Data types
How can we modify structure of
table
To add new field in table
To add new field in table
To add new field in table
To add new field in table
Drop a column
Drop a column

Comment on your result


Modify, Change, Rename
Modify, Change, Rename

You might also like