NULLS can't be changed

[devdash]

how can i allow to edit this yellow section



i know its possible throw edting desgin i guess, but i can't do it at all, need explain please, btw is that will effect anything else? and can i reback it again ? to the yellow...

thanks in advance

[Isoline*]

Originally Posted by alydandy

how can i allow to edit this yellow section



i know its possible throw edting desgin i guess, but i can't do it at all, need explain please, btw is that will effect anything else? and can i reback it again ? to the yellow...

thanks in advance

This doesnt have anything to do with the allow nulls property if that is what you meant, by the looks of it, you cannot insert whatever you want because that column has an identity increment property.

[devdash]

Originally Posted by Isoline*

This doesnt have anything to do with the allow nulls property if that is what you meant, by the looks of it, you cannot insert whatever you want because that column has an identity increment property.

thanks for ur answer i really apprecaite it,

some1 joined my pc before to help me for something, and he did something that allowed him to change numbers in that Yellow Section, and i remember that thing he did was in Desgin


i just can't remember what exactly he did...

[#HB]

As Isoline said, this isn't related to NULL, this is just a IDENTITY_INSERT property. Just set it off. Visit , if you don't know how.

[devdash]

Originally Posted by #HB

As Isoline said, this isn't related to NULL, this is just a IDENTITY_INSERT property. Just set it off. Visit , if you don't know how.

i did that and i clicked on save, then i refreshed the tab and still not change able
so what should i do ? please explain more...

[NorseGodTyr]

Originally Posted by alydandy

i did that and i clicked on save, then i refreshed the tab and still not change able
so what should i do ? please explain more...

This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table:
You change the Allow Nulls setting for a column.
You reorder columns in the table.
You change the column data type.
You add a new column.

[Isoline*]

Originally Posted by alydandy

i did that and i clicked on save, then i refreshed the tab and still not change able
so what should i do ? please explain more...

I dont know what you are trying to accomplish here, but i would not advise you to edit the these stuff, it is a very delicate buisness, there is a reason for the incremental identity property, by looking at the picture you have uploaded, _Char table is definitely not a table to be messed around with, it is dependent on many objects in the database & vice versa, you will screw up your database.

[devdash]

Originally Posted by mialuisa

This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table:
You change the Allow Nulls setting for a column.
You reorder columns in the table.
You change the column data type.
You add a new column.

that's it it working now perfectly, thanks sir i really apprecaite it <3

but i wonder, i pressed yes on both so i can continue is that will effect anything ? i mean is that normally ?



thanks in advance.

[NorseGodTyr]

Originally Posted by alydandy

that's it it working now perfectly, thanks sir i really apprecaite it <3

but i wonder, i pressed yes on both so i can continue is that will effect anything ? i mean is that normally ?



thanks in advance.

its normal yes you can continue idk if any effect i was change it also
if i close identy after my edits i change it back

[devdash]

Originally Posted by mialuisa

its normal yes you can continue idk if any effect i was change it also
if i close identy after my edits i change it back

thanks you make me feel comfortable now,
thanks to everyone tried to help me <3, wish the best for you guys in ur projects & dreams...
Problem Solved.