Transact-SQL 参考

stores

Column_name 数据类型 可为空 默认值 检查 键/索引
stor_id char(4) 聚集主键
stor_name varchar(40)
stor_address varchar(40)
city varchar(20)
state char(2)
zip char(5)

  

下表显示 stores 表的内容。

stor_id stor_name stor_address city state zip
6380 Eric the Read Books 788 Catamaugus Ave. Seattle WA 98056
7066 Barnum's 567 Pasadena Ave. Tustin CA 92789
7067 News & Brews 577 First St. Los Gatos CA 96745
7131 Doc-U-Mat:Quality
Laundry and Books
24-A Avrogado Way Remulade WA 98014
7896 Fricative Bookshop 89 Madison St. Fremont CA 90019
8042 Bookbeat 679 Carson St. Portland OR 89076