Month: December 2007

DDL vs DML vs DCL vs TCL

DDL: Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: * CREATE – to create objects in the database * ALTER – alters the structure of the database * DROP – delete objects from the database * TRUNCATE – remove all records from a table, including all spaces…

Read More

DDL vs DML vs DCL vs TCL

DDL: Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: * CREATE – to create objects in the database * ALTER – alters the structure of the database * DROP – delete objects from the database * TRUNCATE – remove all records from a table, including all spaces…

Read More