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" 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
Re: SOT - Navicat Identity Column
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 it comes with SQL Management Studio, which is much better at managing SQL Server installations and databases. Bonus it's free. https://www.microsoft.com/betaexperience/pd/SQLEXP/enus/ Of course this is all Windows reliant. Byron Mann Lead Engineer & Architect HostMySite.com On Tue, Apr 1, 2014 at 7:04 AM, Kevin Parker 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:358257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SOT - Navicat Identity Column
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" 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