Category: DBMS

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 DR... Read Mores

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 tables in ORACLE: SELECT table_name FROM User_tables; This is how we can extract all tables in SQL Server: SELECT * FROM Information_schema.tables; ... Read Mores

To view tables in SQL, all you need to do is give this command: Show tables; ... Read Mores

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 that is essential for anyone working with relational databases and forms the backbone of their structure. In this article, we will delve into the definition of a primary key, explore its examples, understand its significance, and learn how to choose and implement it effectively. Definition of Primary ... Read Mores

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 management system which would help us organise this database.  There are 4 types of database management systems: Hierarchical Network Relational Object-Oriented. Out of these database management systems, SQL Server comes under the category of Relational database management system.  A re... Read Mores