Here is the solution for that.
We need to setup properties for Management Studio and then we can make changes to our table through designer.
Go to Tools -- > options.
click designer tab and check "table and designers tab" on left side we have following options.
un-check prevent saving changes that require table re-creation and click Ok.
you can also use other powerfull features like create change script is one.
cheers:)
No comments:
Post a Comment