- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Environmental Science
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What are the types of SQL Queries ?
We have four types of SQL Queries:
- DDL (Data Definition Language): the creation of objects
- DML (Data Manipulation Language): manipulation of data
- DCL (Data Control Language): assignment and removal of permissions
- TCL (Transaction Control Language): saving and restoring changes to a database
Let’s look at the different commands under DDL:
Command | Description |
CREATE | Create objects in the database |
ALTER | Alters the structure of the database object |
DROP | Delete objects from the database |
TRUNCATE | Remove all records from a table permanently |
COMMENT | Add comments to the data dictionary |
RENAME | Rename an object |
- Related Questions & Answers
- How to delete a table in SQL ?
- What is Primary Key in SQL ?
- What is SQL server ?
- How to create a table in SQL ?
- How to find the nth highest salary in SQL ?
- What is SQL injection ?
- How to insert multiple rows in SQL ?
- What is OLAP ?
- What is Data Integrity ?
- How to insert date in SQL ?
- What is PL/SQL ?
- What are Nested Triggers ?
- What is Normalization in SQL ?
- How to delete a column in SQL ?
- What is OLTP ?
- What is join in SQL ?
Advertisements
ads