Databases > pubs > Tables > publishers

pubs

publishers

Created: Modified:

Columns

  • pub_id
    [char](4) NOT NULL
    //
    CONSTRAINT
    ([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-9]')
  • pub_name
    [varchar](40) NULL
  • city
    [varchar](20) NULL
  • state
    [char](2) NULL
  • country
    [varchar](30) NULL DEFAULT ('USA')

Indexes

  • UPKCL_pubind
    UNIQUE CLUSTERED
    pub_id

Sample Data

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