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:358256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm