publishers

Transact-SQL Reference

Transact-SQL Reference

publishers

Column_name Data type Nullable Default Check Key/index
pub_id char(4) no yes 1 PK, clust.
pub_name varchar(40) yes
city varchar(20) yes
state char(2) yes
country varchar(30) yes 'USA'

1  The pub_id CHECK constraint is defined as (pub_id = '1756' OR (pub_id = '1622' OR (pub_id = '0877' OR (pub_id = '0736' OR (pub_id = '1389')))) OR (pub_id LIKE '99[0-9][0-0]').

This table shows the contents of the publishers table.

pub_id pub_name city state country
0736 New Moon Books Boston MA USA
0877 Binnet & Hardley Washington DC USA
1389 Algodata Infosystems Berkeley CA USA
1622 Five Lakes Publishing Chicago IL USA
1756 Ramona Publishers Dallas TX USA
9901 GGG&G München NULL Germany
9952 Scootney Books New York NY USA
9999 Lucerne Publishing Paris NULL France