DDL In Table | American Baptist College - Edubirdie

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

2024
Views:

396

Pages:

1
Author:

Venesia A.

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;

Related Documents

DDL In Table

DDL In Table - Page 1

of 1

Recommended Documents

Protect Personal Data

Protect Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Prescriptive Analytics

Prescriptive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Predictive Analytics

Predictive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Motivational Bias and Sampling Bias

Motivational Bias and Sampling Bias

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Show more

New Documents from this Course

Protect Personal Data

Protect Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Prescriptive Analytics

Prescriptive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Predictive Analytics

Predictive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Motivational Bias and Sampling Bias

Motivational Bias and Sampling Bias

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

ITS Databases Practice Exam 25

ITS Databases Practice Exam 25

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

Show more