Category: DBMS
15 posts
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 ... Read Mores
Prathmesh Yelne
19-Dec-2021 16:56:21
How can I see all tables in SQL?
Different database management systems have different queries to see all the tables.
To see all the tables in MYSQL, we would have to use this query:
show tables;
This is how we can see all t... Read Mores
Prathmesh Yelne
14-Dec-2021 17:13:39
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
How do I view tables in SQL ?
To view tables in SQL, all you need to do is give this command:
Show tables;
... Read Mores
Prathmesh Yelne
14-Dec-2021 17:07:50
What is Primary Key in SQL ?
Introduction :
In the world of databases, a primary key is a fundamental concept that plays a crucial role in maintaining data integrity and ensuring efficient data retrieval. It is a concept th... Read Mores
Prathmesh Yelne
24-Jul-2023 17:44:20
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What is SQL server ?
To understand what exactly is SQL Server, we need to understand what is DBMS and RDBMS. DBMS stands for Database Management System. When we have a huge database with us, we would need a proper manage... Read Mores
Prathmesh Yelne
14-Dec-2021 16:57:09