University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2023
Views:

70

Pages:

1
Author:

Muthia M.

DDL In Table A table is a collection of related data held in a table format within a database. It consists of columns and rows. In relational databases, and flat file databases, a table is a set of data elements using a model of vertical columns and horizontal rows, the cell being the unit where a row and column intersect. A. Create Table CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ... ); B. Alter Table 1. Add a Column ALTER TABLE table_name ADD column_name datatype; 2. Modify a Column ALTER TABLE table_name ALTER COLUMN column_name datatype; C. Drop Table DROP TABLE table_name;