: Re: SOT - Navicat Identity Column
Kevin,
I seem remember that in design mode you select the column that you want to
use as identity and at the bottom of the screen there is a selector to set
it as identity. I don't have it in front of me, but seem to remember it
there. You can also set defaults
At the risk of sounding a little daft or maybe missing something that is
plainly obvious if anyone uses Navicat to design MS SQL tables I'd be
grateful for a little help please. I am trying to set an Identity column but
all the identity attributes (identity, seeding, incrementing etc.) are
greyed
Kevin,
I seem remember that in design mode you select the column that you want to use
as identity and at the bottom of the screen there is a selector to set it as
identity. I don't have it in front of me, but seem to remember it there. You
can also set defaults in the same panel.
Hope that
Believe this is how Navicat works if the table already exists. I have
version 10 and can only set the identity column and other optional values
if the table is new and has not been saved yet.
Alternately, I would suggest writing SQL to do the task.
Also you could download SQL Server Express as
4 matches
Mail list logo