{"id":434,"date":"2024-08-28T08:47:57","date_gmt":"2024-08-28T08:47:57","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=434"},"modified":"2025-05-27T09:39:36","modified_gmt":"2025-05-27T09:39:36","slug":"create","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/create\/","title":{"rendered":"CREATE"},"content":{"rendered":"\n

SQL CREATE Keyword<\/h2>\n\n\n\n

The CREATE keyword is used in SQL to define new objects in the database such as databases tables indexes views and procedures.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL CREATE DATABASE Syntax<\/h2>\n\n\n\n

The CREATE DATABASE command is used to create a new database.<\/p>\n\n\n\n

CREATE DATABASE database_name<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE DATABASE Example<\/h2>\n\n\n\n
MySQL \/ SQL Server \/ Oracle \/ MS Access<\/strong>:<\/p>\n\n\n\n
CREATE DATABASE EngineDB<\/pre><\/div>\n\n\n\n
\n
Note:<\/em><\/strong> SQLite including our TechKubo playground does not support CREATE DATABASE. Databases are created as separate files outside SQL through the system or interface.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE TABLE Syntax<\/h2>\n\n\n\n
The CREATE TABLE command is used to create a new table in the database.<\/p>\n\n\n\n
CREATE TABLE table_name (\n    column1 datatype,\n    column2 datatype,\n    ...\n)<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE TABLE Example<\/h2>\n\n\n\n
This creates a table named Vehicles with five columns.<\/p>\n\n\n\n
CREATE TABLE Vehicles (\n    VehicleID INT,\n    Brand VARCHAR(255),\n    EngineSize INT,\n    FuelType VARCHAR(100),\n    Origin VARCHAR(255)\n)<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE TABLE Using Another Table Syntax<\/h2>\n\n\n\n
The CREATE TABLE AS statement creates a new table by copying columns and data from an existing table.<\/p>\n\n\n\n
CREATE TABLE new_table AS\nSELECT column1 column2\nFROM existing_table<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE TABLE Using Another Table Example<\/h2>\n\n\n\n
CREATE TABLE PopularBrands AS\nSELECT Brand FuelType\nFROM Vehicles<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Note:<\/em><\/strong> This syntax will work in SQLite only if the source table and data exist. You may need to insert sample data first before seeing results.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE INDEX Syntax<\/h2>\n\n\n\n
The CREATE INDEX command is used to speed up searches on a table. Indexes can be created on one or more columns.<\/p>\n\n\n\n
CREATE INDEX index_name\nON table_name (column1 column2 ...)<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE INDEX Example<\/h2>\n\n\n\n
This creates an index on the Brand column in the Vehicles table.<\/p>\n\n\n\n
CREATE INDEX idx_brand\nON Vehicles (Brand)<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Note:<\/em><\/strong> Index creation is supported in SQLite. Keep in mind that indexes make queries faster but may slow down inserts and updates.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE UNIQUE INDEX Syntax<\/h2>\n\n\n\n
The CREATE UNIQUE INDEX command creates an index that does not allow duplicate values.<\/p>\n\n\n\n
CREATE UNIQUE INDEX index_name\nON table_name (column)<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE UNIQUE INDEX Example<\/h2>\n\n\n\n
This ensures that each VehicleID is unique in the table.<\/p>\n\n\n\n
CREATE UNIQUE INDEX uidx_vehicleid\nON Vehicles (VehicleID)<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE VIEW Syntax<\/h2>\n\n\n\n
The CREATE VIEW command defines a virtual table based on a SELECT query.<\/p>\n\n\n\n
CREATE VIEW view_name AS\nSELECT column1 column2\nFROM table_name\nWHERE condition<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE VIEW Example<\/h2>\n\n\n\n
This creates a view showing only vehicles from Japan.<\/p>\n\n\n\n
CREATE VIEW JapaneseVehicles AS\nSELECT Brand EngineSize\nFROM Vehicles\nWHERE Origin = 'Japan'<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE OR REPLACE VIEW Example<\/h2>\n\n\n\n
The CREATE OR REPLACE VIEW command updates an existing view with a new definition.<\/p>\n\n\n\n
CREATE OR REPLACE VIEW JapaneseVehicles AS\nSELECT Brand EngineSize FuelType\nFROM Vehicles\nWHERE Origin = 'Japan'<\/pre><\/div>\n\n\n\n
\n
Note:<\/em><\/strong> This example is not supported in SQLite. SQLite supports only CREATE VIEW and requires manually dropping the view before recreating it.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE Query the View Example<\/h2>\n\n\n\n
To use a view simply query it as if it were a table.<\/p>\n\n\n\n
SELECT * FROM Vehicles<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE PROCEDURE Syntax<\/h2>\n\n\n\n
The CREATE PROCEDURE command creates a stored procedure. A procedure is a saved SQL block that can be executed repeatedly.<\/p>\n\n\n\n
CREATE PROCEDURE procedure_name\nAS\nSQL statements<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE PROCEDURE Example<\/h2>\n\n\n\n
CREATE PROCEDURE SelectAllVehicles\nAS\nSELECT * FROM Vehicles\nGO<\/pre><\/div>\n\n\n\n
Execute procedure<\/strong>:<\/p>\n\n\n\n
EXEC SelectAllVehicles<\/pre><\/div>\n\n\n\n
\n
Note:<\/em><\/strong> SQLite does not support stored procedures. This feature is available only in MySQL SQL Server Oracle and similar systems.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL CREATE Labs<\/h2>\n\n\n\n