Anonymous Asked in Cars &Transportation · 2 weeks ago

How do you create a student table?

SolutionCreating student table. . Describe the structure of the table. . Insert few records into student table. . Add column to the student table (that is phone_no). . Modify the column name of phone_no to student_no. . Rename the table name to student_info. . Delete any records from the table.


How do you make a student table?

If you want to create a table, you should name the table and define its column and each column's data type.1create table "tablename"2("column1" "data type",3"column2" "data type",4"column3" "data type",5...6"columnN" "data type");

How do I make a table?

Answer1Open a blank Word document.2In the top ribbon, press Insert.3Click on the Table button.4Either use the diagram to select the number of columns and rows you need, or click Insert Table and a dialog box will appear where you can specify the number of columns and rows.5The blank table will now appear on the page.

How do you create a database table?

Create a new table in a new database1Click File > New, and then select Blank desktop database.2In the File Name box, type a file name for the new database.3To browse to a different location and save the database, click the folder icon.4Click Create.

How do I make an employee table?

CREATE TABLE Employee( EmpId integer, FirstName varchar(20), LastName varchar(20), Email varchar(25), PhoneNo varchar(25), Salary integer ); Above, Employee is the name of the table, and EmpId , FirstName , LastName , Email , PhoneNo , HireDate , and Salary are the columns.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours