Scribd
Upload
4 views4 pages

SQL Lab Screenshots

The document contains screenshots demonstrating the use of DROP TABLE and TRUNCATE TABLE SQL commands within a database management tool. It shows the initial state of the database, the effects of the DROP TABLE operation, and the state of the student_table before and after the TRUNCATE TABLE operation. The final screenshot highlights that while the table structure remains intact, all data rows have been cleared.

Uploaded by

جياد الشدادي
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views4 pages

SQL Lab Screenshots

The document contains screenshots demonstrating the use of DROP TABLE and TRUNCATE TABLE SQL commands within a database management tool. It shows the initial state of the database, the effects of the DROP TABLE operation, and the state of the student_table before and after the TRUNCATE TABLE operation. The final screenshot highlights that while the table structure remains intact, all data rows have been cleared.

Uploaded by

جياد الشدادي
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL Lab Exercises: GUI Screenshots

This document presents a series of screenshots simulating a database management


tool environment, illustrating the DROP TABLE and TRUNCATE TABLE SQL commands.

1. Initial Database State

This screenshot shows the initial state of the database, displaying all tables
( Employee_table , Proj_tab , and student_table ) before any modification.

2. After DROP TABLE Operations

This image captures the database state after executing DROP TABLE commands for
Employee_table and Proj_tab . Only student_table remains.
3. Before TRUNCATE TABLE Operation

This screenshot displays the contents of the student_table before the TRUNCATE
TABLE operation, showing the existing records.
4. After TRUNCATE TABLE Operation

This image illustrates the student_table after the TRUNCATE TABLE command. The
table structure is preserved, but all data rows have been removed.

You might also like