1. First things first; make all the columns NOT NULL since there is no good reason to allow them to be NULL. 2. Most SQL programmers immediately think in terms of adding a PRIMARY KEY, so you might ...
Joe Celko is an independent consultant and author living in Austin, Texas. He was a member of the ANSI X3H2 Database Standards Committee from 1987 to 1997 and helped write the ANSI/ISO SQL-89 and ...