Answer to Question #218499 in Databases | SQL | Oracle | MS Access for Gershon Korley

Question

1. Use an SQL statement to create a table called employees with the following attributes
I. Employee_id
II. Employee_name
III. Gender
IV. Department_id
2. Use an SQL statement to confirm the structure of the table.

Answer 1

1..

CREATE TABLE Employees (
    Employee_id int,
    Employee_name varchar(20),
    Gender varchar(10),
    Department_id INT,
  	PRIMARY KEY(Employee_id)
)

2..

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='Employee'