Saturday, July 3, 2010

SQL Statement Types


AcronymLanguagePurposeStatementsComments
DDLData DefinitionDefine Database· Create · Alter · Drop · Truncate · Comment · RenameAutocommit
DMLData ManipulationManaging data· Select · Insert · Update · Delete · Merge
· Call · Explain Plan · Lock Table
Can rollback
DCLData ControlSecurity· Grant · Revoke
TCLTransaction Control Manage DML· Commit · Savepoint · Rollback · Set Transaction

No comments:

Post a Comment