How do I create a table in Microsoft SQL

Create & Use Database

Write a command to create the database you want to use for your table if you don't already have one. Highlight the command and execute.



CREATE DATABASE NewDatabase



Make sure you are using the database. You can execute the command.



USE NewDatabase

Create Table

Write a command to create the new table and specify the table name. List the table columns, data type and any other criteria you would like to include, separated by commas. Enclose the entire set of columns in parentheses. Highlight and execute the command.



CREATE TABLE NewTable

(

NewColumn varchar(30) NOT NULL,

FirstName varchar(35),

LastName varchar(35),

Address varchar(75)

)