Thanks Scott - I can see it but its greyed out too which doesn't make sense - I'll keep poking around - thank you again
++++++++++ Kevin Parker ++++++++++ -----Original Message----- From: Scott Slone [mailto:ssl...@rubbergumball.net] Sent: Tuesday, 1 April 2014 11:50 PM To: cf-talk Subject: 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 in the same panel. Hope that helps. Scott Sent from my iPad > On Apr 1, 2014, at 4:04 AM, "Kevin Parker" <tras...@internode.on.net> wrote: > > > 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 out for the column of choice, in fact > all columns of any type - have set the column as an int - Navicat help > is extremely basic and unhelpful and Googling it wasn't much better. > > > > I'm using Navicat Premium v 11 > > > > Thank you!! > > > > > > ++++++++++ > > Kevin Parker > > > > ++++++++++ > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm