Member Avatar for Kusno

Dear all,

How do I change primary key field from query because if I use VS Designer, raised an error about time expired ?

I want to extend my FK field length.

Thanks

  • 3 Contributors
  • 5 Replies
  • 128 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Kusno
Member Avatar for Ramy Mahrous

Open new query document and copy the script and paste it there.

Member Avatar for Kusno

Open new query document and copy the script and paste it there.

:confused:

Sorry, I don't get at...
Could you explain me more ? :$

Member Avatar for sknake

These are the instructions for SQL 2005, i'm sure it is similar for other versions but you may need to check. Open up the table in the designer and make the changes you want --- but don't apply them. On the top menu you will see "Table Designer" (to the right of file, view, etc) and under that you will see a menu option for "Generate Change Script". Click that and it will open up a window with a query in it. Copy that query to your clipboard, close the window, then close the table designer but DO NOT save. Pop open a new query window, paste in the change script, then take the evening off and wait for it to run.

commented: well said! +7
commented: Cool...!!! Two thumbs up +2
Member Avatar for Ramy Mahrous

Greate, Sknake

Member Avatar for Kusno

Oh my God, It works....Thanks a lot

:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.