This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Using T-SQL to create tables programmatically Part four of a four-part series of blogs
SQL doesn’t just select data; you can also use it to create tables and link them together with relationships. This blog shows you how! Creating Tables in SQL Creating Databases using SQL Creating a Table Programmatically in SQL Linking Tables (Foreign Keys and Relationships) (this blog) This blog is part of a much longer tutorial on programming in SQL. Alternatively, have a look at our classroom-based training courses in SQL.

Using T-SQL to create tables programmatically

Part four of a four-part series of blogs

SQL doesn’t just select data; you can also use it to create tables and link them together with relationships. This blog shows you how!

This blog is part of a much longer tutorial on programming in SQL. Alternatively, have a look at our classroom-based training courses in SQL.

Posted by Andy Brown on 05 October 2012

Linking Tables (Foreign Keys and Relationships)

This page of the blog shows you how to create links between two tables (or foreign key constraints, if yoiu want to be technical).

Our Example

Suppose we create two tables: one to hold authors, and one to hold books:

-- create table of authors

CREATE TABLE tblAuthor (

AuthorId int IDENTITY(1,1) PRIMARY KEY,

FirstName varchar(100),

LastName varchar(100)

)

-- add in a couple of authors

INSERT INTO tblAuthor(FirstName,LastName)

VALUES ('Stieg','Larsson')

INSERT INTO tblAuthor(FirstName,LastName)

VALUES ('John','Wyndham')

-- now create a table of books

CREATE TABLE tblBook(

BookId int IDENTITY(1,1) PRIMARY KEY,

BookName varchar(100) not null,

AuthorId int

)

-- add a few books