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.
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 ;)
Adding a new field to an already existing table?
Posted - 07/18/2012 : 07:29:35
I should not have tabbed away from Chrome without clicking "Post" button, or I could have beaten Fred ;)