Understand Tables and How to Create Them. LESSON 2.2. 98-364 Database Administration Fundamentals. Lesson Overview In this lesson, you will learn: What is ANSI SQL syntax ? What is a table? Why are tables used? How are tables created?. What is ANSI?
98-364 Database Administration Fundamentals
In this table, “William” is a junction of a Row and Column. The cell is called FirstName, and the data type is Vchar of size 20. These cells make up the table.
CREATE TABLE table_name(column_name1 data_type,column_name2 data_type,column_name3 data_type,...)
CREATE TABLE student_info
(student_id char(9) not null,
first_name char(20) not null,
last_name char(20) not null,
address char(40) not null,
city char(20) not null)
Create a table that will store the students’ final grades for this class.