All articles: Data Definition Language (DDL)

Checkout our self-help content, created by our top Experts!
Linear Hash and Key Partitioning in MySQL – Querychat
In this article, we will check the Linear Hash and Key partitioning in MySQL, including simplified examples for better understanding. Linear Hash Table Partitioning This MySQL table partitioning is derived from the regular hash table partitioning. The main difference between these methods is that the linear hash partitioning uses a...
Database Snapshots in SQL Server – Querychat
Database snapshots are read-only copies of a database, allowing us to view the data as they were at a specific point in time. We can create database snapshots for reporting, training, testing, or data recovery purposes. In this article, we will learn the basics of database snapshots in SQL Server,...
Fill Factor in SQL Server – Querychat
When designing databases in SQL Server, an important role of the process is for sure its performance. The fill factor is directly connected with indexes that plays a significant part in the performance tuning area. This article elaborates on what fill factor is and how it can be defined on...
How to Delete a User From MySQL – Querychat
In this article, we will discover how to remove a user or several users from our MySQL server and strip their accounts of all available rights. One simple command will be used for this. MySQL users MySQL system is an entity for storing information in the form of tables. So...
How to Create a Table IF NOT EXISTS in MySQL – Querychat
In this article, we will discover the basics of the EXIST clause and IF NOT EXISTS option in MySQL and also test it in a practical example. Also, we will learn how to create a table with the IF NOT EXIST clause as part of exploring the EXIST option. EXISTS...
Generating Sequential GUIDs using NEWSEQUENTIALID Function – Querychat
In SQL Server, there are two functions we can use to generate GUID values; those are NEWID and NEWSEQUENTIALID functions. Whereas NEWID provides random values, NEWSEQUENTIALID generates incremental uniqueidentifier values. In this article, we will learn how to use the NEWSEQUENTIALID function and understand its use.  Note: This article only...
How to Delete a Database in MySQL – Querychat
MySQL is one of the most common database management systems on the Internet today. This system is used to work with sufficiently large amounts of information. However, MySQL is ideal for both small and large Internet projects. An important feature of the system is that it's free. Reliability, high speed,...
Specifying the Stored Procedure’s Security Context – Querychat
SQL Server allows a user to execute blocks of code as another user. It can be achieved by adding the EXECUTE AS clause to the CREATE or ALTER command for stored procedures, as well as functions, triggers, and queues. In this article, we will learn how to use this clause...
Returning Random Rows using TABLESAMPLE – Querychat
When doing data analysis, we might need to select a random sample of data from a table to get an idea about the data distribution. SQL Server has the TABLESAMPLE clause that we can use to return a random set of rows. In this article, we will learn how TABLESAMPLE...
Nonclustered Indexes in SQL Server – Querychat
In SQL Server, we can only have one clustered index that physically sorts the table based on the clustering key. However, we can add secondary sorting based on other columns by adding nonclustered indexes. In this article, we will learn the basics of nonclustered indexes and several examples of how...
1 2 14 15