Create Example

To generate a new table, we'll only need to pass the names of the columns and their data types. For example, if you wanted to store a concept like "names", then you'll likely use the data type varchar(255) (varchar stands for variable character fields, and the 255 refers to how 255 characters has historically often been the maximum length of these fields). Other options are available as well.

Let's create a new table called Class, which will store the information of students.

The attached query will generate the following table.

xxxxxxxxxx

CREATE TABLE Class(StudentID int,

                   StudentName varchar(255),

                   CoursesEnrolled varchar(255),

                   Attendance int);