|
|
��< H T M L > < H E A D >
< M E T A N A M E = " C O P Y R I G H T " C O N T E N T = " 2 0 0 8 � P a w J e r s h a u g e " >
< M E T A N A M E = " D E S C R I P T I O N " C O N T E N T = " T h i s s i t e c o n t a i n s i n f o r m a t i o n a b o u t t h e S Q L R e a d e r C l a s s L i b r a r y . " >
< M E T A N A M E = " A U T H O R " C O N T E N T = " P a w J e r s h a u g e " >
< M E T A N A M E = " C O D I N G " C O N T E N T = " P a w J e r s h a u g e " >
< M E T A N A M E = " D E V E L O P E R " C O N T E N T = " P a w J e r s h a u g e [ h t t p : / / p a w . j e r s h a u g e . d k ] " >
< M E T A N A M E = " G E N E R A T O R " C O N T E N T = " A s s e m b l y T o H T M L b y P a w J e r s h a u g e " >
< L I N K R E L = " S T Y L E S H E E T " T Y P E = " T E X T / C S S " H R E F = " . . / d a t / m s d n 2 . c s s " > < / L I N K > < S C R I P T L A N G U A G E = " J a v a s c r i p t 1 . 2 " S R C = " . . / d a t / j s c r . j s " > < / S C R I P T >
< T I T L E > S Q L R e a d e r b y P a w J e r s h a u g e < / T I T L E > < / H E A D > < B O D Y C L A S S = " t y p e c l a s s " o n u n l o a d = " w o ( ' . . / t o o l b a r . h t m ' , ' T O O L B A R ' ) ; C u r r e n t O b j e c t ( ' . . . ' ) ; " >
< P C L A S S = " m e d i u m " > < I M G S R C = " . . / i m g / m i n u s . g i f " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d m g R " I D = " c o l l a p s e _ e x p a n d i m g " N A M E = " c o l l a p s e _ e x p a n d i m g " > < A N A M E = " c o l l a p s e _ e x p a n d " h r e f = " # c o l l a p s e _ e x p a n d " o n c l i c k = " p l u s m i n u s t g l c o n t e n t s h o w i n g ( ) ; t g l C o n t e n t ( ) ; " C L A S S = " l i k e t e x t " > C o l l a p s e / E x p a n d c o n t e n t < / A > < / P >
S Q L R e a d e r C l a s s L i b r a r y
< H 1 > f o r e i g n _ k e y P u b l i c C l a s s < / H 1 >
< P > < B > N a m e s p a c e : < / B > < A H R E F = " S Q L R e a d e r . h t m " > S Q L R e a d e r < / A > < / P >
< P > < B > A s s e m b l y : < / B > < A H R E F = " S Q L R e a d e r ( 1 . 0 . 0 . 0 ) . h t m " > S Q L R e a d e r < / A > ( i n S Q L R e a d e r . d l l ) < / P >
< P > < B > B a s e t y p e ( s ) : < / B > < A H R E F = " S Q L R e a d e r . A b s t r a c t S Q L O b j e c t . h t m " T A R G E T = " _ s e l f " > S Q L R e a d e r . A b s t r a c t S Q L O b j e c t < / A > < / P >
< H 3 > I n t h i s d o c u m e n t t h e f o l l o w i n g h i g h l i g h t a r e a v a i l a b l e : < / H 3 >
< U L > < L I > < A H R E F = " # A N A M E _ P r o p e r t y B o x " > P r o p e r t i e s ( 2 7 ) < / A > < / L I > < L I > < A H R E F = " # A N A M E _ S e e A l s o _ R e f B o x " > S e e a l s o < / A > < / L I > < / U L > < A N A M E = " A N A M E _ P r o p e r t y B o x " > < / A > < H 2 C L A S S = " c l k " o n c l i c k = " p l u s m i n u s t g l ( ' P r o p e r t y B o x ' ) ; " > < I M G S R C = " . . / i m g / m i n u s . g i f " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d m g R " I D = " P r o p e r t y B o x I m g " N A M E = " P r o p e r t y B o x I m g " > P r o p e r t i e s < / H 2 >
< T A B L E C E L L P A D D I N G = " 0 " C E L L S P A C I N G = " 0 " B O R D E R = " 0 " W I D T H = " 1 0 0 % " I D = " P r o p e r t y B o x " N A M E = " P r o p e r t y B o x " > < T R > < T D C L A S S = " t d h e a d " > & n b s p ; < / T D > < T D C L A S S = " t d h e a d " > N a m e < / T D > < T D C L A S S = " t d h e a d " > T y p e < / T D > < T D C L A S S = " t d h e a d " > D e s c r i p t i o n < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > c r e a t e _ d a t e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . D a t e T i m e . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > D a t e T i m e < / A > < / T D > < T D C L A S S = " t d i t e m " > D a t e t h e o b j e c t w a s c r e a t e d & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > d e l e t e _ r e f e r e n t i a l _ a c t i o n < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B y t e . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B y t e < / A > < / T D > < T D C L A S S = " t d i t e m " > T h e r e f e r e n t i a l a c t i o n t h a t w a s d e c l a r e d f o r t h i s F O R E I G N K E Y w h e n a d e l e t e h a p p e n s .
0 = N o a c t i o n
1 = C a s c a d e
2 = S e t n u l l
3 = S e t d e f a u l & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > d e l e t e _ r e f e r e n t i a l _ a c t i o n _ d e s c < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > D e s c r i p t i o n o f t h e r e f e r e n t i a l a c t i o n t h a t w a s d e c l a r e d f o r t h i s F O R E I G N K E Y w h e n a d e l e t e o c c u r s :
N O _ A C T I O N
C A S C A D E
S E T _ N U L L
S E T _ D E F A U L & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > F o r e i g n K e y C o l u m n s < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y _ c o l u m n s . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > f o r e i g n _ k e y _ c o l u m n s < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ d i s a b l e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > F O R E I G N K E Y c o n s t r a i n t i s d i s a b l e d & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ m s _ s h i p p e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > O b j e c t i s c r e a t e d b y a n i n t e r n a l S Q L S e r v e r c o m p o n e n t & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ n o t _ f o r _ r e p l i c a t i o n < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > F O R E I G N K E Y c o n s t r a i n t w a s c r e a t e d b y u s i n g t h e N O T F O R R E P L I C A T I O N o p t i o n & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ n o t _ t r u s t e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > F O R E I G N K E Y c o n s t r a i n t h a s n o t b e e n v e r i f i e d b y t h e s y s t e m & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ p u b l i s h e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > O b j e c t i s p u b l i s h e d & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ s c h e m a _ p u b l i s h e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > O n l y t h e s c h e m a o f t h e o b j e c t i s p u b l i s h e d & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ s y s t e m _ n a m e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = N a m e w a s g e n e r a t e d b y t h e s y s t e m .
0 = N a m e w a s s u p p l i e d b y t h e u s e r & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > k e y _ i n d e x _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e k e y i n d e x w i t h i n t h e r e f e r e n c e d o b j e c t & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > m o d i f y _ d a t e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . D a t e T i m e . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > D a t e T i m e < / A > < / T D > < T D C L A S S = " t d i t e m " > D a t e t h e o b j e c t w a s l a s t m o d i f i e d b y u s i n g a n A L T E R s t a t e m e n t . I f t h e o b j e c t i s a t a b l e o r a v i e w , m o d i f y _ d a t e a l s o c h a n g e s w h e n a c l u s t e r e d i n d e x o n t h e t a b l e o r v i e w i s c r e a t e d o r a l t e r e d & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > n a m e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > O b j e c t n a m e . & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > o b j e c t _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > O b j e c t i d e n t i f i c a t i o n n u m b e r . I s u n i q u e w i t h i n a d a t a b a s e . & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c V i r t u a l P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > O b j e c t N a m e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > O w n e r < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y s . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > f o r e i g n _ k e y s < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > p a r e n t _ o b j e c t _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e o b j e c t t o w h i c h t h i s o b j e c t b e l o n g s .
0 = N o t a c h i l d o b j e c t & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > p r i n c i p a l _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e i n d i v i d u a l o w n e r , i f d i f f e r e n t f r o m t h e s c h e m a o w n e r . B y d e f a u l t , s c h e m a - c o n t a i n e d o b j e c t s a r e o w n e d b y t h e s c h e m a o w n e r . H o w e v e r , a n a l t e r n a t e o w n e r c a n b e s p e c i f i e d b y u s i n g t h e A L T E R A U T H O R I Z A T I O N s t a t e m e n t t o c h a n g e o w n e r s h i p .
I s N U L L i f t h e r e i s n o a l t e r n a t e i n d i v i d u a l o w n e r .
I s N U L L i f t h e o b j e c t t y p e i s o n e o f t h e f o l l o w i n g :
C = C H E C K c o n s t r a i n t
D = D E F A U L T ( c o n s t r a i n t o r s t a n d - a l o n e )
F = F O R E I G N K E Y c o n s t r a i n t
P K = P R I M A R Y K E Y c o n s t r a i n t
R = R u l e ( o l d - s t y l e , s t a n d - a l o n e )
T A = A s s e m b l y ( C L R - i n t e g r a t i o n ) t r i g g e r
T R = S Q L t r i g g e r
U Q = U N I Q U E c o n s t r a i n & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > r e f e r e n c e d _ o b j e c t _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e r e f e r e n c e d o b j e c t & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > R e f e r e n c e d _ T a b l e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . T a b l e . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > T a b l e < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > s c h e m a _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e s c h e m a t h a t t h e o b j e c t i s c o n t a i n e d i n .
F o r a l l s c h e m a - s c o p e d s y s t e m o b j e c t s t h a t s h i p w i t h S Q L S e r v e r 2 0 0 5 , t h i s v a l u e w i l l a l w a y s b e
I N ( s c h e m a _ i d ( ' s y s ' ) , s c h e m a _ i d ( ' I N F O R M A T I O N _ S C H E M A ' ) ) & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > t y p e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . O b j e c t _ T y p e . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > O b j e c t _ T y p e < / A > < / T D > < T D C L A S S = " t d i t e m " > O b j e c t t y p e :
A F = A g g r e g a t e f u n c t i o n ( C L R )
C = C H E C K c o n s t r a i n t
D = D E F A U L T ( c o n s t r a i n t o r s t a n d - a l o n e )
F = F O R E I G N K E Y c o n s t r a i n t
P K = P R I M A R Y K E Y c o n s t r a i n t
P = S Q L s t o r e d p r o c e d u r e
P C = A s s e m b l y ( C L R ) s t o r e d p r o c e d u r e
F N = S Q L s c a l a r f u n c t i o n
F S = A s s e m b l y ( C L R ) s c a l a r f u n c t i o n
F T = A s s e m b l y ( C L R ) t a b l e - v a l u e d f u n c t i o n
R = R u l e ( o l d - s t y l e , s t a n d - a l o n e )
R F = R e p l i c a t i o n - f i l t e r - p r o c e d u r e
S = S y s t e m b a s e t a b l e
S N = S y n o n y m
S Q = S e r v i c e q u e u e
T A = A s s e m b l y ( C L R ) D M L t r i g g e r
T R = S Q L D M L t r i g g e r
I F = S Q L i n l i n e t a b l e - v a l u e d f u n c t i o n
T F = S Q L t a b l e - v a l u e d - f u n c t i o n
U = T a b l e ( u s e r - d e f i n e d )
U Q = U N I Q U E c o n s t r a i n t
V = V i e w
X = E x t e n d e d s t o r e d p r o c e d u r e
I T = I n t e r n a l t a b l & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > t y p e _ d e s c < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > D e s c r i p t i o n o f t h e o b j e c t t y p e .
A G G R E G A T E _ F U N C T I O N
C H E C K _ C O N S T R A I N T
D E F A U L T _ C O N S T R A I N T
F O R E I G N _ K E Y _ C O N S T R A I N T
P R I M A R Y _ K E Y _ C O N S T R A I N T
S Q L _ S T O R E D _ P R O C E D U R E
C L R _ S T O R E D _ P R O C E D U R E
S Q L _ S C A L A R _ F U N C T I O N
C L R _ S C A L A R _ F U N C T I O N
C L R _ T A B L E _ V A L U E D _ F U N C T I O N
R U L E
R E P L I C A T I O N _ F I L T E R _ P R O C E D U R E
S Y S T E M _ T A B L E
S Y N O N Y M
S E R V I C E _ Q U E U E
C L R _ T R I G G E R
S Q L _ T R I G G E R
S Q L _ I N L I N E _ T A B L E _ V A L U E D _ F U N C T I O N
S Q L _ T A B L E _ V A L U E D _ F U N C T I O N
U S E R _ T A B L E
U N I Q U E _ C O N S T R A I N T
V I E W
E X T E N D E D _ S T O R E D _ P R O C E D U R E
I N T E R N A L _ T A B L & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c V i r t u a l P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > U n i q u e O b j e c t N a m e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > u p d a t e _ r e f e r e n t i a l _ a c t i o n < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B y t e . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B y t e < / A > < / T D > < T D C L A S S = " t d i t e m " > T h e r e f e r e n t i a l a c t i o n t h a t w a s d e c l a r e d f o r t h i s F O R E I G N K E Y w h e n a n u p d a t e h a p p e n s .
0 = N o a c t i o n
1 = C a s c a d e
2 = S e t n u l l
3 = S e t d e f a u l & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > u p d a t e _ r e f e r e n t i a l _ a c t i o n _ d e s c < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > D e s c r i p t i o n o f t h e r e f e r e n t i a l a c t i o n t h a t w a s d e c l a r e d f o r t h i s F O R E I G N K E Y w h e n a n u p d a t e h a p p e n s :
N O _ A C T I O N
C A S C A D E
S E T _ N U L L
S E T _ D E F A U L & n b s p ; < / T D > < / T R >
< / T A B L E >
< H 2 C L A S S = " c l k " o n c l i c k = " p l u s m i n u s t g l ( ' S e e A l s o _ R e f B o x ' ) ; " > < I M G S R C = " . . / i m g / m i n u s . g i f " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d m g R " I D = " S e e A l s o _ R e f B o x I m g " N A M E = " S e e A l s o _ R e f B o x I m g " > S e e A l s o : < / H 2 >
< A N A M E = " A N A M E _ S e e A l s o _ R e f B o x " > < / A > < D I V I D = " S e e A l s o _ R e f B o x " N A M E = " S e e A l s o _ R e f B o x " >
& b u l l ; < A H R E F = " S Q L R e a d e r . A b s t r a c t S Q L O b j e c t . h t m " T A R G E T = " _ s e l f " > S Q L R e a d e r . A b s t r a c t S Q L O b j e c t < / A >
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . O b j e c t _ T y p e . h t m " T A R G E T = " _ s e l f " > O b j e c t _ T y p e < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y _ c o l u m n s . h t m " T A R G E T = " _ s e l f " > f o r e i g n _ k e y _ c o l u m n s < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y s . h t m " T A R G E T = " _ s e l f " > f o r e i g n _ k e y s < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . T a b l e . h t m " T A R G E T = " _ s e l f " > T a b l e < / A > < / S P A N > & n b s p ; & n b s p ;
< / D I V >
< S C R I P T L A N G U A G E = " J a v a s c r i p t 1 . 2 " >
p a r e n t . M E N U . S h D i v ( ' S Q L R e a d e r ( 1 . 0 . 0 . 0 ) _ A s s e m b l y ' ) ;
p a r e n t . M E N U . S h D i v ( ' S Q L R e a d e r . S Q L R e a d e r _ N a m e s p a c e ' ) ;
p a r e n t . M E N U . S h D i v ( ' S Q L R e a d e r . S Q L R e a d e r _ C l a s s ' ) ;
p a r e n t . M E N U . l o c a t i o n = p a r e n t . M E N U . l o c a t i o n + ' # S Q L R e a d e r _ S Q L R e a d e r . f o r e i g n _ k e y ' ;
C o p y R i g h t ( ' C o p y r i g h t � P a w J e r s h a u g e 2 0 0 8 ' ) ;
C u r r e n t O b j e c t ( ' f o r e i g n _ k e y C l a s s ' ) ;
< / S C R I P T >
< / B O D Y > < / H T M L >
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Submit an article or tip