<div>
<div class="content wysiwyg-content">
I have a table that has over 100 columns, though isn't the widest table I have. However, anytime I use MS SQL Management Studio to try to modify the table by adding a new column, it crashes SQL management studio. Likewise even if I try to &quot;drop table xxxx&quot;, the query hangs forever. &nbsp;It seems to be the only table in this database and the table has only about 200 records. All nightly data integrity checks come out ok. What else should I try to be able to either drop or alter this table?
</div>
</div>


I have a table that has over 100 columns, though isn't the widest table I have. However, anytime I use MS SQL Management Studio to try to modify the table by adding a new column, it crashes SQL management studio. Likewise even if I try to "drop table xxxx", the query hangs forever.  It seems to be the only table in this database and the table has only about 200 records. All nightly data integrity checks come out ok. What else should I try to be able to either drop or alter this table?

Alter or drop table failing on MS SQL 2012

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.