tag:blogger.com,1999:blog-36914164.post7260518699473768845..comments2023-05-03T04:43:30.936-07:00Comments on Persistence of Vision: Does Teradata Support BIT Columns? Yes and No.Rob Garrisonhttp://www.blogger.com/profile/09779841540941950357noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-36914164.post-44683324827943051232011-03-28T20:57:09.971-07:002011-03-28T20:57:09.971-07:00The ColumnLength of 1 is deceiving. That is 1 byte...The ColumnLength of 1 is deceiving. That is 1 byte of data and will accept values between -128 and 127. If you want to ensure that 1 and 0 are all that is captured you will need to include a column constraint.Rob Pallerhttp://robpaller.comnoreply@blogger.comtag:blogger.com,1999:blog-36914164.post-12411623377469024762010-12-07T14:52:58.360-08:002010-12-07T14:52:58.360-08:00Another option for seeing the tables structure is ...Another option for seeing the tables structure is this:<br /><br />SHOW TABLE test1;Rob Garrisonhttps://www.blogger.com/profile/09779841540941950357noreply@blogger.com