lecture-06-sql-data-definition-constraints

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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 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 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 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 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 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 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....
View Full Document

This note was uploaded on 12/24/2011 for the course CS 4604 taught by Professor Cmmalik during the Fall '08 term at Virginia Tech.

Page1 / 90

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

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online