All articles: Data Definition Language (DDL)

Checkout our self-help content, created by our top Experts!
Find Database Name in SQL – Querychat
In this article, we are going to discuss, how to find database names, how to find the current database and how to set the current database. Detailed information and examples are included for both SQL Server and MySQL. How to find Database Names in MySQL The below command is used...
Setting the NLS_DATE_FORMAT parameter in Oracle – Querychat
Oracle offers various initialization parameters whose value defines the behavior of the database. The value of these variable initialization parameters can be modified to improve the system's performance.  In this article, we will learn about the Oracle nls_date_format parameter, how to check its default value, and different ways of modifying...
The Main SQL Terms Used in the Query Code – Querychat
In this article, we will discover what the main SQL terms are and what is the purpose of their use. Also, we will look at practical examples. What are SQL terms By terms, we mean the statements, which are the foundation of the query code. Statements are what SQL consists...
MySQL Column Count and Row Size limitations – Querychat
In this article, we will check on the Column count and row size limitations for MySQL tables, including several examples for better understanding. Column Count Limitations The maximum amount of columns allowed in a table for MySQL is 4096. Depending on certain aspects, this amount can less than 4096 per...
MySQL InnoDB Row Formats – Querychat
In this article, we will check the MySQL InnoDB Row formats, and how to define it, including simplified examples for better understanding. By knowing how to save information in a specific format, we can improve performance for DML statements. It can help us save storage space, decreasing queries response time,...
How to work with SQLite create table if not exists and drop table if exists sentences – Querychat
In this article, we will learn how to use the SQLite create table if not exist and SQLite drop table if exists statements. SQLite create table if not exists This clause must be placed at the beginning of the sentence we use to create a table. Its function is to...
How to Debug and Fix MySQL Error 1022 – Querychat
In RDBMS, foreign keys are used to represent a relationship between two tables. While creating the child table, a foreign key constraint is created that refers to the primary key of the parent table. In this article, we will learn how to debug and solve MySQL Error 1022, which is...
Understanding the Concept of Weak Entity in RDBMS – Querychat
In this article, we will understand the concept of a weak entity, their representation in ER-Diagram, and the difference between Strong and weak entity. Entity An Entity is an identifiable object in the real world that can have physical or conceptual existence. The examples of an entity with physical existence...
How to download, install and execute queries on sakila sample database in MySQL – Querychat
Mike is a former member of the MySQL documentation team has initially developed the sakila database. The purpose was to provide the standard schema that can be used for tutorials, samples, articles, etc. The Sakila database is a perfectly normalized schema modeling a DVD rental store application, emphasizing things like...
ORACLE create user identified by – Querychat
Creating a user in Oracle multitenant environment, there are two options, first is by a common user that has access to entire multitenant container database and second, a local user that is specified to every pluggable database. In the use of Oracle SQL CREATE USER statement, we can assign a...
1 2 10 11