Creating Tables

This post will build off the I Break Code's Create Database post where a database was created with the name "Library".

The following SQL statements will create two tables with some columns called "Books" and "Authors".

1. USE Library;
3. CREATE TABLE Books
4. (
5.     book_ID int identity(1,1) PRIMARY KEY
6.     , title varchar(50) NOT NULL
7.     
8.     , genre varchar(25)
9.     , description varchar(100)
10. );
12. CREATE TABLE Authors
13. (
14.     author_ID int identity(1,1) PRIMARY KEY
15.     , first_Name varchar(25) NOT NULL
16.     , last_Name varchar(50) NOT NULL
17. );

The tables will be created with some columns inside of them. If you don't understand some of the syntax, just post a comment and I'll try to reply to it either directly or with a post explaining that topic.