|
|
Posted by Tony Rogerson on 11/27/07 05:39
> Sorry, Tony, but sometimes Joe is right. An IDENTITY column cannot be
> nullable, and you can only have one of them in a table. Not that see
> any practical importance of this.
Ok - point 1 is right, granted.
The IDENTITY isn't a column, it's a property of the column - you can't have
two PRIMARY KEY's either!
Tony.
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
Navigation:
[Reply to this message]
|