Question

Using SQL syntax, what statement would you use to create an Employee table with the information FirstName, LastName, and EmployeeID.

Answer 1

The Create table command in SQL is used to create a new table in the SQL database.

The command is given as follows:

----------------------------Command--------------------------------------

CREATE TABLE Employee (
EmployeeID int,

    FirstName varchar(255),

LastName varchar(255));

-----------------------------------------------------------------------------------

The above SQL command is used to create a table named employee with three columns employee id, first name, and last name.

-----------------------------------------------------------Please Upvote--------------------------------------------------------