To create a table using T-SQL is quite simple

This is a simple example of how to create a table. Note, a primary key is recommended. This will be covered in another post.

USE databasename

CREATE TABLE tablename

(

ID int NOT NULL,

FirstName char(15) NOT NULL,

LastName char(20) NOT NULL

);