About us |  Help us improve
intelliVERB - Get a fair search of the Internet !
Visual studio .net
SQL Server
Oracle
Main  >  DDL Commands Email this page to friend
ALTER
CREATE
DROP
RENAME
TRUNCATE
 
 
 
 
 

DDL: Data Definition Language

DDL command are used to define database structure and components. 

CREATE : to create database objects

ALTER : alters database object structure

DROP : delete objects from the database

TRUNCATE :  removes all data rows from a table. Truncate commend cannot be ROLLBACK.

COMMENT : add comments to the data dictionary .

RENAME : rename an object.


PLSQLTRUNCATETop

Syntax:
TRUNCATE TABLE [TableName][DROP STORAGE];
Empty a Table And Move Highwater Mark
Simple Truncate will drop storage even if DROP STORAGE is not specified

Ex:
TRUNCATE TABLE Employee DROP STORAGE;
TRUNCATE TABLE Employee;

Syntax:
TRUNCATE TABLE [TableName]REUSE STORAGE;
Empty Table And Do Not Move Highwater Mark

Ex:
TRUNCATE TABLE Employee REUSE STORAGE;

Syntax:
ALTER TABLE [TableName] TRUNCATE PARTITION [PartitionName];
Truncate a single partition in a partitioned Table

Ex:
ALTER TABLE Employee
TRUNCATE PARTITION Sales;

You last visited
Oracle basic functions
Remoting
Web Objects
Inheritance C# .net
XML
Assemblies
DDL Sql Server
Sql Server Basic functions
COM +
DML Sql Server
 
 
Make a secure donation now with PayPal!