Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kingsofleo
Starting Member
7 Posts |
 Posted - 2012-07-18 : 07:29:35
|
| Hi all,I'm looking to add a new field to an already existing table and it won't let me. I'm not sure if this is a permissions issue or not.It's SQL 2008 I'm working with. I'm used to SQL 2000 and before I could just go to the table in question, right click > Design View and add it there and save but with SQL 2008 it doesn't seem to work. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-18 : 07:39:12
|
Please tell us the steps you are doing and tell us what happens."it doesn't seem to work" isn't a great help for us to help you.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-18 : 07:47:19
|
I tried to do that on my SQL 2008 where I have administrative privileges, and it works exactly as you described. So it may be a permissions issue. Do you see any messages/warnings/popups?You can also add a column using T-SQL with this syntax - you would get an error message if you don't have the required permissions:ALTER TABLE YourTableName ADD YourNewColumnName VARCHAR(32);  I should not have tabbed away from Chrome without clicking "Post" button, or I could have beaten Fred ;) |
|
|
|
kingsofleo
Starting Member
7 Posts |
Posted - 2012-07-18 : 08:38:04
|
Thanks guys.I'm pretty sure it's a permissions issue since I can't do anything of what sunitabeck suggested.Thanks for your help  |
|
|
|
|
|
|
Adding a new field to an already existing table?