/ * * * * * *   O b j e c t :     T a b l e   [ d b o ] . [ C u s t o m e r s ]         S c r i p t   D a t e :   0 2 / 0 8 / 2 0 0 5   1 7 : 1 5 : 4 4   * * * * * * / 
 
 S E T   A N S I _ N U L L S   O N 
 
 G O 
 
 S E T   Q U O T E D _ I D E N T I F I E R   O N 
 
 G O 
 
 C R E A T E   T A B L E   [ d b o ] . [ C u s t o m e r s ] ( 
 
 	 [ C u s t o m e r I D ]   [ n c h a r ] ( 5 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N O T   N U L L , 
 
 	 [ C o m p a n y N a m e ]   [ n v a r c h a r ] ( 4 0 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N O T   N U L L , 
 
 	 [ C o n t a c t N a m e ]   [ n v a r c h a r ] ( 3 0 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ C o n t a c t T i t l e ]   [ n v a r c h a r ] ( 3 0 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ A d d r e s s ]   [ n v a r c h a r ] ( 6 0 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ C i t y ]   [ n v a r c h a r ] ( 1 5 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ R e g i o n ]   [ n v a r c h a r ] ( 1 5 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ P o s t a l C o d e ]   [ n v a r c h a r ] ( 1 0 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ C o u n t r y ]   [ n v a r c h a r ] ( 1 5 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ P h o n e ]   [ n v a r c h a r ] ( 2 4 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ F a x ]   [ n v a r c h a r ] ( 2 4 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L 
 
 )   O N   [ P R I M A R Y ] 
 
 
 
 G O 
 
 S E T   A N S I _ N U L L S   O F F 
 
 G O 
 
 S E T   Q U O T E D _ I D E N T I F I E R   O F F 
 
 G O 
 
 / * * * * * *   O b j e c t :     T a b l e   [ d b o ] . [ P r o d u c t s ]         S c r i p t   D a t e :   0 2 / 0 8 / 2 0 0 5   1 7 : 1 5 : 4 4   * * * * * * / 
 
 S E T   A N S I _ N U L L S   O N 
 
 G O 
 
 S E T   Q U O T E D _ I D E N T I F I E R   O N 
 
 G O 
 
 C R E A T E   T A B L E   [ d b o ] . [ P r o d u c t s ] ( 
 
 	 [ P r o d u c t I D ]   [ i n t ]   I D E N T I T Y ( 1 , 1 )   N O T   N U L L , 
 
 	 [ P r o d u c t N a m e ]   [ n v a r c h a r ] ( 4 0 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N O T   N U L L , 
 
 	 [ S u p p l i e r I D ]   [ i n t ]   N U L L , 
 
 	 [ C a t e g o r y I D ]   [ i n t ]   N U L L , 
 
 	 [ Q u a n t i t y P e r U n i t ]   [ n v a r c h a r ] ( 2 0 )   C O L L A T E   S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S   N U L L , 
 
 	 [ U n i t P r i c e ]   [ m o n e y ]   N U L L , 
 
 	 [ U n i t s I n S t o c k ]   [ s m a l l i n t ]   N U L L , 
 
 	 [ U n i t s O n O r d e r ]   [ s m a l l i n t ]   N U L L , 
 
 	 [ R e o r d e r L e v e l ]   [ s m a l l i n t ]   N U L L , 
 
 	 [ D i s c o n t i n u e d ]   [ b i t ]   N O T   N U L L 
 
 )   O N   [ P R I M A R Y ] 
 
 
 
 G O 
 
 S E T   A N S I _ N U L L S   O F F 
 
 G O 
 
 S E T   Q U O T E D _ I D E N T I F I E R   O F F 
 
 G O 
 
 