#4 SQL DDL Commands | CREATE, ALTER, DROP, RENAME, TRUNCATE | #SQL

In this video, You will learn about SQL DDL Commands i.e. CREATE, ALTER, DROP, RENAME, TRUNCATE. After watching this video, you will understand Data Definition Language (DDL).

Timestamps(minutes:seconds)
0:00 Introduction
0:06 DDL Statements
0:16 DDL expansion
0:44 Create
1:36 DESC command
2:06 Alter
2:28 Add column by using alter
4:24 Rename column by using alter
5:25 Modify datatype by using alter
7:10 Drop column by using alter
8:59 Table name rename
10:14 Clear screen by using clear icon
10:39 Truncate
11:26 Open one new sql worksheet
12:26 Drop
13:01 Insert
13:26 How to execute multiple sql statemets?
14:40 Difference between Truncate and Drop
15:22 End

📌 DDL Commands Covered:
CREATE TABLE - Define new tables and structures
ALTER TABLE - Modify existing database elements
DROP TABLE - Remove tables and objects
RENAME TABLE - Changes the name of a user-created object in the current database. This object can be a table, index, column etc.
TRUNCATE TABLE - Quickly clear table data

🔎 Examples Shown in This Video:

CREATE TABLE T1
(
A NUMBER
);

DESC T1;

ALTER TABLE T1
ADD B NUMBER;

ALTER TABLE T1
RENAME COLUMN B TO C;

ALTER TABLE T1
MODIFY C VARCHAR2(20);

DESC T1;

ALTER TABLE T1
DROP COLUMN C;

RENAME T1 TO T2;
RENAME T2 TO T1;

DESC T1;

DESC T2;
SELECT * FROM T3;

TRUNCATE TABLE T3;
SELECT * FROM T1;

INSERT INTO T1 VALUES(10);
INSERT INTO T1 VALUES(20);
INSERT INTO T1 VALUES(30);

DROP TABLE T1;
👉 Don’t forget to Like 👍, COMMENT 💬, 🔁 Share, Subscribe 🔔, and Turn on Notifications. So you never miss a new lesson from Pavunu Education!

🔔 Subscribe here : https://www.youtube.com/@PavunuEducation

#sql #oracle #data #analytics

Видео #4 SQL DDL Commands | CREATE, ALTER, DROP, RENAME, TRUNCATE | #SQL канала Pavunu Education