Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Transact-SQL CREATEs

 /* 1. Create database with GUI tools or with CREATE DATABASE command. 2. Connect to bookbiz database with GUI tools or with USE command. 3. Load entire script. Ignore error messages for DROP commands. 4. Use the INSERT script to add data. */ --create database bookbiz --go --use bookbiz --go --DROP TABLE and CREATE TABLE commands drop table authors go create table authors (au_id char(11) not null, au_lname varchar(40) not null, au_fname varchar(20) not null, phone char(12) null, address varchar(40) null, city varchar(20) null, state char(2) null, zip char(5) null) go grant select on authors to public go drop table publishers go create table publishers (pub_id char(4) not null, pub_name varchar(40) null, address varchar(40) ...