<div>
Do you want to remove the column from the table.<b> If yes it is not possible with dropping depending object like constrains and indexes in SQL Server.</b>
</div>


<div>
hi jj <br />
all the tables &nbsp;with selected columns copied on to a different database with the 'Select * Into...' clause from one server to another. But this statement does not transfer constraints and indexes. How do we transfer the constraints and indexes to the destination server.
</div>


<div>
Generate Scripts is the answer-<br />
<br />
Go to &nbsp;SSMS -&gt; Choose your database -&gt; tasks-&gt; Generate scripts -&gt; Next<br />
-&gt; Script Check Constraints to true <br />
-&gt; Script Indexes &nbsp;to true <br />
-&gt; ScriptDependencies to true <br />
-&gt; Select the tables you need <br />
-&gt; next -&gt; next -&gt; <br />
<br />
read more from <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/17a16dc4-dcf1-4de8-baba-6949c55a4c5d/copy-constraints-and-indexes-from-one-database-to-another?forum=transactsql" rel="ugc nofollow">here</a>
</div>


<div>
i need selected columns alone if i use the generate scripts it comes all the column in the specified table jj. iam doing now trunctate table and selecting the columns &nbsp;and inserting . &nbsp;like this<br />
<br />
<br />
if OBJECT_ID(N'LGen_Arbitrati<wbr />onExpenses<wbr />_D', N'U') is not null<br />
&nbsp; &nbsp; Truncate Table LGen_ArbitrationExpenses_D<wbr />;<br />
<br />
&nbsp;Insert into &nbsp;LGen_ArbitrationExpenses_D<wbr /> &nbsp;(Pk_Id,Amount,CrtdBy,CrtdD<wbr />t,ExpenseD<wbr />t,ExpenseT<wbr />ype,Hdr_Fk<wbr />,HearingDa<wbr />te,LnNo,Ln<wbr />No_Fk,LstM<wbr />odDt,Media<wbr />Name,Publi<wbr />cationAgai<wbr />nst,Public<wbr />ationDt)<br />
&nbsp;select Pk_Id,Amount,CrtdBy,CrtdDt<wbr />,ExpenseDt<wbr />,ExpenseTy<wbr />pe,Hdr_Fk,<wbr />HearingDat<wbr />e,LnNo,LnN<wbr />o_Fk,LstMo<wbr />dDt,MediaN<wbr />ame,Public<wbr />ationAgain<wbr />st,Publica<wbr />tionDt &nbsp;<br />
&nbsp;from [192.169.1.77\sql12].SHRIC<wbr />ITYUNO.dbo<wbr />.LGen_Arbi<wbr />trationExp<wbr />enses_D &nbsp;with(nolock)<br />
<br />
&nbsp;Go<br />
<br />
is tere any way to do simple and common script jj.
</div>


<div>
<div class="content wysiwyg-content">
how to move selected column in the &nbsp;table from one server to another server with out droping constrains and indexes in sql server 2012.
</div>
</div>


how to move selected column in the  table from one server to another server with out droping constrains and indexes in sql server 2012.

sql server index 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.

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.