Fixed

SQL SCRIPT CREATES "ON PRIMARY" (SQL SERVER)

fa 10 anys • updated by fa 10 anys • 8

If you build a create table script for SQL Server, it fails to run; "ON PRIMARY" is added at the end of all indexes, tables, etc. - since "PRIMARY" is a reserved word, the script won't work.

Changing the script from "ON PRIMARY" to "ON [PRIMARY]" fixes the issue; could this be done at point of generation?

Vote

Replies 8
vells primer
- nous primer
- vells primer

Under review

fa 10 anys

Respondre
- És això?
- Inadequat
- Spam
- Duplicat
|

Not a bug

fa 10 anys

We would like to keep the script generation mechanism as simple as possible. Simplicity is our general idea. Adding an extra condition will make it more complex, less obvious, and finally it'll become source of frustration for our users and us.

I recommend you should simply put "[PRIMARY]" in the text field as in the picture. This is solution not a workaround :)

Respondre
- És això?
- Inadequat
- Spam
- Duplicat
|

fa 10 anys

Hi Rafal, no offence, but it's a pretty poor solution! As standard, any table I create is allocated to ON PRIMARY; to then make the user go in an change everything to [ON PRIMARY] feels a little too much like additional effort for the user.

Also, I can't see an option to change this for indecies..? They're output as ON PRIMARY too... Perhaps an option to set defaults is required?

Respondre
- És això?
- Inadequat
- Spam
- Duplicat
|

Planned

fa 10 anys

Hi Craig,
There is an option to set defaults but doesn't work as it should be. I've planned to give an instruction but found a bug. grrr. I think it will be fixed in the next week. Please be patient and sorry for inconvenience.