Tag: create table

Make sure you are using the correct database;

USE MyDatabase;
GO

Create a table.

CREATE TABLE employees
(
  employee_id   INT IDENTITY(1,1) PRIMARY KEY,
  first_name    VARCHAR(30),
  middle_names  VARCHAR(100),
  last_name     VARCHAR(30),
  date_of_birth DATE
)

Insert some data.

INSERT INTO employees (first_name, middle_names, last_name, date_of_birth)
VALUES ('Peter', NULL, 'Parker', '2007-05-08');

Display the data in the table.

SELECT * FROM employees;

Drop the table.

DROP TABLE employees;

For more information see:

• CREATE TABLE (Transact-SQL)
• DROP TABLE (Transact-SQL)
• Data Types (Transact-SQL)