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 one 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 (this blog) Creating Databases using SQL Creating a Table Programmatically in SQL Linking Tables (Foreign Keys and Relationships) 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 one 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 (this blog)
Creating Databases using SQL
Creating a Table Programmatically in SQL
Linking Tables (Foreign Keys and Relationships)

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

Creating Tables in SQL

This blog shows how you can use SQL to create tables. All of the SQL that you'll need will be shown as we go along. Just before we begin, though, let's look at two alternatives to writing SQL code.

Alternatives to Creating Tables Programmatically

It probably goes without saying, but you don't need to write SQL script to create tables:

You can design tables in SQL Server Management Studio (SSMS), specifiying for each column a name and a data type.

Scripting Table Creation

If you already have a table, you can use this to generate SQL script:

You can right-click on any table in SSMS and choose to create a new table from it.

This will generate script, which you can then edit as you see fit:

A small part of the script generated by the above menu option.

However, this blog is going to concentrate on writing script from scratch.

If you're wondering why this might be a useful thing to do, SQL works with sets of rows at a time, and it's frequently useful to create ad hoc temporary tables to hold these.

To start with, let's look at how you might first create a database to hold your tables.

Parts of this blog
Creating Tables in SQL (this blog) Creating Databases using SQL Creating a Table Programmatically in SQL Linking Tables (Foreign Keys and Relationships)

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Creating Tables in SQL

Alternatives to Creating Tables Programmatically

Scripting Table Creation

Head office

London

Manchester