I have made three attempts to post a topic in the SQL forum. Although all three appear to have posted, I get an error 403 trying to view them? And since the original was posted days ago and got 0 views, I assume everyone else gets error 403 too
Announcement
Collapse
No announcement yet.
I can't post in SQL any more?
Collapse
X
-
Okay I don't think it's the SQL forum. I think it's something about the content of my post - like some combination of words or characters is tripping up the forum database (the 403 error says Wordfence detected a potentially unsafe operation, maybe it's incorrectly valdating my post as an executable statement). I'm going to do some experimentation in the Off Topic forum later to try and narrow it down.
-
Originally posted by UserName10 View PostTake a screenshot of the text and post the image.
Comment
-
In SQL, when you create a Primary Key constraint, the DB engine will create an implicit index to enforce the rules of a Primary Key constraint (unique, not null, etc). So you end up with a separate index anyway. If you're still creating PF's in DDS, then it still good practice to separate the UNIQUE constraint into a Logical to make things more obvious. It also gives you the ability to drop the UNIQUE logical/constraint in the event you need to modify the values in the key fields but can't guarantee that the keys will be unique until the update is finished.
Comment
Comment