{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lecture-06-sql-data-definition-constraints

lecture-06-sql-data-definition-constraints - Data Denition...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Definition Data Modification Project Constraints Keys and Foreign Keys Attribute and Tuple Constraints Data Definition, Modification, and Constraints T. M. Murali September 8, 2010 T. M. Murali September 8, 2010 CS4604: Data Definition, Modification, and Constraints
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Data Definition Data Modification Project Constraints Keys and Foreign Keys Attribute and Tuple Constraints Data Types in SQL I Character strings: I CHAR(n) : fixed-length string of n characters, with padding, if necessary. I VARCHAR(n) : string of length of upto n characters. T. M. Murali September 8, 2010 CS4604: Data Definition, Modification, and Constraints
Background image of page 2
Data Definition Data Modification Project Constraints Keys and Foreign Keys Attribute and Tuple Constraints Data Types in SQL I Character strings: I CHAR(n) : fixed-length string of n characters, with padding, if necessary. I VARCHAR(n) : string of length of upto n characters. I Bit strings: I BIT(n) : bit string of length n . I BIT VARYING(n) : bit string of length upto n . T. M. Murali September 8, 2010 CS4604: Data Definition, Modification, and Constraints
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Data Definition Data Modification Project Constraints Keys and Foreign Keys Attribute and Tuple Constraints Data Types in SQL I Character strings: I CHAR(n) : fixed-length string of n characters, with padding, if necessary. I VARCHAR(n) : string of length of upto n characters. I Bit strings: I BIT(n) : bit string of length n . I BIT VARYING(n) : bit string of length upto n . I BOOLEAN : possible values are TRUE , FALSE , and T. M. Murali September 8, 2010 CS4604: Data Definition, Modification, and Constraints
Background image of page 4
Data Definition Data Modification Project Constraints Keys and Foreign Keys Attribute and Tuple Constraints Data Types in SQL I Character strings: I CHAR(n) : fixed-length string of n characters, with padding, if necessary. I VARCHAR(n) : string of length of upto n characters. I Bit strings: I BIT(n) : bit string of length n . I BIT VARYING(n) : bit string of length upto n . I BOOLEAN : possible values are TRUE , FALSE , and UNKNOWN (read Chapter 6.1.6 and 6.1.7). T. M. Murali September 8, 2010 CS4604: Data Definition, Modification, and Constraints
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Data Definition Data Modification Project Constraints Keys and Foreign Keys Attribute and Tuple Constraints Data Types in SQL I Character strings: I CHAR(n) : fixed-length string of n characters, with padding, if necessary. I VARCHAR(n) : string of length of upto n characters. I Bit strings: I BIT(n) : bit string of length n . I BIT VARYING(n) : bit string of length upto n . I BOOLEAN : possible values are TRUE , FALSE , and UNKNOWN (read Chapter 6.1.6 and 6.1.7). I integers: INTEGER ( INT ), SHORTINT . T. M. Murali September 8, 2010 CS4604: Data Definition, Modification, and Constraints
Background image of page 6
Data Definition Data Modification Project Constraints Keys and Foreign Keys Attribute and Tuple Constraints Data Types in SQL I Character strings: I CHAR(n) : fixed-length string of n characters, with padding, if necessary.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}