09/05/2018 Database SQL

SQL command

DDL: Data Definition Language

Command	Description
create	To create new table or database
alter	For alteration
truncate	Delete data from table
drop	To drop a table
rename	To rename a table

DML: Data Manipulation Language

Command	Description
insert	To insert a new row
update	To update existing row
delete	To delete a row
merge	Merging two rows or two tables

TCL: Transaction Control Language

Command	Description
commit	to permanently save
rollback	to undo change
savepoint	to save temporarily

DCL: Data Control Language

Command	Description
grant	grant permission of right
revoke	take back permission.

DQL: Data Query Language

Command	Description
select	retrieve records from one or more table