Hi, I am trying to run alter table command on a particular able to add a column to it using the following command:
***alter table tab_name add col_name int***
And after typing the command when click Run button, the command keeps on running and doesn't stop even after a long time.And if i manually stop it nothings happens to be done.
But i am able to alter table with the same command on any other table but not on this particular table.
Any ideas where i can be doing wrong, what should i check or edit any settings. or What can be the possible reasons i am not able to run alter table command on a particular table.
asked 31 Mar '13, 01:54
The comments there apply to all versions prior to 16. Either your ALTER statement is waiting for a lock because another connection has an uncommitted transaction that references the table you are trying to alter or the table is large and the server is busy rewriting all of the rows of the table.
answered 31 Mar '13, 07:12