Create database:
CREATE DATABASE mytest;
go

Use the mytest database:
USE mytest;
go

Create a table:
CREATE TABLE Persons (
    PersonID int IDENTITY(1,1) PRIMARY KEY,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);
go

Insert some data:
INSERT INTO Persons 
VALUES (N'Martinson', N'Jim', N'15 5th Ave NW', N'Hutchinson')
	 , (N'Doe', N'John', N'123 1st st', N'Willmar')
	 , (N'Doe', N'Jane', N'123 1st st', N'Willmar')
;
go

Drop a table:
DROP table Persons;
go

List tables:
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE';
go