Difference between SQL TRUNCATE & SQL DROP
SQL - Difference between TRUNCATE & DROP
DROP TABLE - deletes the table from the database. TRUNCATE TABLE - empties it, but leaves the structure for future data.
skip to main |
skip to sidebar
Oracle SQL & PL/SQL
- SQL Introduction
- SQL Syntax
- SQL Select
- SQL Insert
- SQL Update
- SQL Delete
- SQL Joins
- SQL Examples of Joins
- SQL Explicit vs. Implicit Joins
- SQL Group By
- SQL Group By Examples
- SQL Having
- SQL - IN
- SQL - NULLs
- Functional Dependencies
- Normalization
- ACID Properties
- SQL SubQueries
- SQL - Queries With Examples
- SQL Views
- Insert, Update, Delete Views
- SQL Join Views
- SQL Inline Views
- SQL - Nth Highest Salary
- SQL Second Highest Salary
- SQL - Difference Truncate / Delete
- SQL - Difference Truncate / Drop
- SQL - Difference HAVING / WHERE
- SQL - Difference CAST / CONVERT
- SQL - Difference NOT IN / NOT EXIST
- SQL - Difference IN / EXISTS
- SQL - Difference UNION / UNION ALL
- SQL - Difference Nested / Correlated Subquery
- SQL - REPLACE
- SQL - TOP
- SQL - LIKE
- SQL - SELECT INTO
- SQL - CREATE TABLE
- SQL - CREATE TABLE (More Examples)
- SQL - ALTER TABLE
- SQL - Difference views / Materialized views
- SQL Count
- SQL Update
- SQL Clustered / Non-Clustered Indexes
- SQL - Delete Duplicate Records
- SQL - Difference Unique/Primary Key
- SQL - GETDATE()
- SQL - DATEDIFF()
- SQL - DATEADD()
- SQL - DATEPART()
- SQL - Convert()
- SQL - SUM()
- SQL - AVG()
- SQL - MIN()
- SQL - MAX()
- SQL - Insert Into Select
- SQL - Insert Multiple Values In Table
- SQL - Referential Integrity
- SQL - Not Null Constraint
- SQL - Unique Constraint
- SQL - Primary Key Constraint
- SQL - Foreign Key Constraint
- SQL - Default Constraint
- SQL - Check Constraint
- SQL - ROLLUP
- SQL - CUBE
- SQL - STUFF()
- SQL - Count_Big
- SQL - Binary_Checksum
- SQL - Checksum_AGG
- SQL - Index Include
- SQL - Covered Query
- SQL - Identity
- SQL - sp_columns
- SQL - Diff Local/Global Temporary Tables
- SQL - Stored Procedure
- SQL - sp_who
- SQL - Session
- SQL - Dynamic SQL
- SQL - SQL Server Execution Plan
- SQL - sp_executesql
- SQL - Difference Execute/Execute()
- SQL - Case Expression
- SQL - XML Variable Example
- SQL - Pivot
- SQL - Merge
- SQL - Compute / Compute by
- SQL - Diff SCOPE_IDENTITY / IDENT_CURRENT / @@IDENTITY
- SQL Coalesce
- SQL - Import Data into SQL Server Table
- SQL - Delete Duplicate Records in SQL Server Table
- SQL - Check If a Column Exists in SQL Server Table
- SQL - Has_perms_by_name
- SQL Interview Questions
- PL/SQL Introduction
- PL/SQL Procedures
- PL/SQL Functions
- PL/SQL Collections
- PL/SQL Records
- PL/SQL Table Based Records
- PL/SQL Programmer Defined Records
- PL/SQL Cursor Based Records
- PL/SQL Tables
- PL/SQL Varrays
- PL/SQL Nested Tables
- PL/SQL Loops
- PL/SQL Triggers
- PL/SQL Cursors
- PL/SQL Implicit Cursors
- PL/SQL Explicit Cursors
- PL/SQL REF Cursors
- PL/SQL Cursor For Loop
- PL/SQL Cursors with Parameters
- PL/SQL Where Current Of and For Update
- Examples of PL/SQL Cursors
- PL/SQL Exceptions
- PL/SQL Interview Questions
- SQL PL/SQL Sitemap
Oracle SQL
Oracle PL/SQL