Vaibhav_PreventSavingChanges.jpg

<div>
Thanks you. &nbsp;I am pretty new to SQL Server. &nbsp;How would I accomplish a structure update to an existing table in T=SQL?
</div>


Thanks you.  I am pretty new to SQL Server.  How would I accomplish a structure update to an existing table in T=SQL?

<div>
<div class="content wysiwyg-content">
I have been making some table structure changes in the SQL DB. &nbsp;I added a new field to one of the SQL tables (tblDevleoper), clicked the 'Save' icon and the revision was saved.<br />
<br />
I tried to revise another table (tblProperty_LandFile_Hist<wbr />ory) in the DB but when I clicked the 'Save' I got the screen below.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/12_w51/1215848/EESaveSQLTableChanges.jpg" target="_blank" title="SQL Error Msg (85 KB)"><img alt="SQL Error Msg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/12_w51/800_1215848/EESaveSQLTableChanges.jpg" /></a><br />
Why am I seeing the message on this table but not the other table?<br />
<br />
In case it is pertinent, tblDevleoper only has three fields and about 10 records. &nbsp;tblProperty_LandFile_Histo<wbr />ry' has about 50 fields and contains over 10 million records.
</div>
</div>


EESaveSQLTableChanges.jpg

I have been making some table structure changes in the SQL DB.  I added a new field to one of the SQL tables (tblDevleoper), clicked the 'Save' icon and the revision was saved.

I tried to revise another table (tblProperty_LandFile_History) in the DB but when I clicked the 'Save' I got the screen below.


Why am I seeing the message on this table but not the other table?

In case it is pertinent, tblDevleoper only has three fields and about 10 records.  tblProperty_LandFile_History' has about 50 fields and contains over 10 million records.

Error when trying to save table revisions SQL 2014 Developer

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.