{"id":665,"date":"2024-09-04T06:55:16","date_gmt":"2024-09-04T06:55:16","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=665"},"modified":"2025-06-07T03:49:11","modified_gmt":"2025-06-07T03:49:11","slug":"table","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/table\/","title":{"rendered":"TABLE"},"content":{"rendered":"\n

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

The TABLE keyword is used in several SQL statements such as CREATE TABLE, ALTER TABLE, DROP TABLE, and TRUNCATE TABLE. These commands allow you to create, modify, and delete tables in a database.<\/p>\n\n\n\n

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

SQL CREATE TABLE Syntax<\/h2>\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 query creates a new table named Rooms<\/code> with four columns.<\/p>\n\n\n\n
CREATE TABLE Rooms (\n    room_id INTEGER,\n    room_type TEXT,\n    capacity INTEGER,\n    floor_number INTEGER\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
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
This query creates a new table DoctorsBackup<\/code> that copies data from Doctors<\/code>.<\/p>\n\n\n\n
CREATE TABLE DoctorsBackup AS\nSELECT doctor_id, specialty\nFROM Doctors;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL ALTER TABLE Syntax<\/h2>\n\n\n\n
ALTER TABLE table_name\nADD column_name datatype;<\/pre><\/div>\n\n\n\n
ALTER TABLE table_name\nDROP COLUMN column_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL ALTER TABLE ADD COLUMN Example<\/h2>\n\n\n\n
This query adds a new column room_color<\/code> to the Rooms<\/code> table.<\/p>\n\n\n\n
ALTER TABLE Rooms\nADD room_color TEXT;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL ALTER TABLE DROP COLUMN Example<\/h2>\n\n\n\n
ALTER TABLE Rooms\nDROP COLUMN room_color;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL DROP TABLE Syntax<\/h2>\n\n\n\n
DROP TABLE table_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL DROP TABLE Example<\/h2>\n\n\n\n
This query deletes the Rooms<\/code> table.<\/p>\n\n\n\n
DROP TABLE Rooms;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL TRUNCATE TABLE Syntax<\/h2>\n\n\n\n
TRUNCATE TABLE table_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL TRUNCATE TABLE Example<\/h2>\n\n\n\n
TRUNCATE TABLE Patients;<\/pre><\/div>\n\n\n\n
\n
Note:<\/strong> This syntax does not work in TechKubo playground. SQLite does not support the TRUNCATE TABLE<\/code> command. Use DELETE FROM table_name;<\/code> instead if needed.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL TABLE Labs<\/h2>\n\n\n\n