Create student table using sql statement

How to create a student table using SQL statements: First open the new SQL query and create a new table; then enter the student number and name, and the type is represented by characters; then enter the gender, age, and major; finally click Execute Can.

The operating environment of this article: Windows 7 system, SQL Server 2016 version, Dell G3 computer.

How to create a student table using sql statements:

1. We open a new query in sql

2. We create a table called student

3. We enter the student number and name, and the type is represented by characters

4. We enter gender, age, and major, and define them with appropriate types.

5. At this time, we press execute

6. We can see that the system shows that the table was successfully created.

Related learning recommendations: SQL video tutorial

The above is the detailed content of Create student table using sql statement. For more information, please follow other related articles on the PHP Chinese website!