nullable columns | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

nullable columns

Please, tell me the reason of having table in database without
a primary key & all columns nullable.
Thanks.
The cynic in me says "Laziness, Ignorance and/or former Access developer" [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />All tables should have a PK. It is one of the fundamental principles of relational database theory and is used to uniquely identify a row inside a table.<br /><br /><br />———————–<br />–Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />———————–<br />
You could theoretically have a table used for imports setup this way. If you never knew what data, or the quality of any of your data, you would be getting it might make sense to have a temporary staging table build like this. I’d be willing to be that’s not the case here though. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
An interesting discussion fromhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136 link.
Fyi. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>