All articles: Data Definition Language (DDL)

Checkout our self-help content, created by our top Experts!
All articles Data Definition Language (DDL)
Let’s talk about MS Access data types – Querychat
In this article, we will discover the indispensable part of MS Access, namely the table fields data types. Every time we create a table in MS Access we need to choose the type of data that will be used in table fields. These types decide what data will be stored...
How to create a table in SQL Server Management Studio – Querychat
SQL Server Management Studio can be used to create databases and their tables, write and execute database queries, and many more. In this article, we will find out how to create a table in SQL Server Management Studio. Downloading the SQL Server Management Studio SQL Server Management Studio (SSMS for...
MySQL Views Having WITH CHECK OPTION – Querychat
MySQL allows users to create views which act as windows to the data residing in the database. Views also allow database administrators to restrict data retrieval. However, through MySQL views, it is possible to update data in the underlying table. MySQL views when used with "WITH CHECK OPTION" allows for...
Using the SYSNAME special Data type in SQL – Querychat
In this article, we will check what the SYSNAME special Data type is and use it in several examples for better understanding.  SQL SYSNAME Data type is considered part of the variable-length character data types in SQL, which is the nvarchar data type. The difference between these two is that...
How to create an EER Diagram with Workbench – Querychat
In this article, we will learn how to create an EER Diagram for a new database with Workbench. What is an EER Diagram? EER are the initials of Enhanced Entity-Relationship. The EER Diagrams are an improvement of the ER Diagrams. The goal of both is to create database models through...
MySQL create roles and apply to users – Querychat
MySQL roles contain names of a set of privileges that can be given to users or can also be revoked from its users. The roles can be applied with various combinations of privileges to limit user access in certain database tables. In this article, we will learn how MySQL create...
MySQL myd, myi, and frm files – Querychat
MySQL creates three files per table when the data engine for that table is MyISAM. In this article, we will learn how to verify the creation of those files. MyISAM MyISAM was the default data storage engine of MySQL up to version 5.5. From there, InnoDB replaced MyISAM as the...
How to migrate from PostgreSQL to MySQL with Workbench – Querychat
In this article, we will learn how to migrate a PostgreSQL database to MySQL using Workbench. In addition to PostgreSQL and MySQL, we are going to need Workbench. If you do not have it installed you can download the installer from the official site: https://www.mysql.com/products/workbench/ After having installed Workbench, we...
SQL Server Primary Key Constraints and Violations – Querychat
The primary key constraint is one of database constraints that is used to enforce the uniqueness of every row in a table. When we insert a row into a table, we might accidentally insert duplicate values and cause an error. This article demonstrates how to add a primary key constraint...
User Access Modes in SQL SERVER – Querychat
SQL SERVER gives an option to restrict access of database for users. This can be done by selecting appropriate access mode for the database. In SQL Server, we have three access modes, SINGLE USER, MULTIPLE USER, and RESTRICTED USER. In this article, we will discuss how to set access mode...
1 2 6 7