Changes

Create Table SDC(

Tgt_Industry varchar(50100), Tgt_Nation varchar(10100),

Acq_Ind varchar(10100), Acq_Nation varchar(10100), Pc_Shares_Acq floatvarchar(100), Pc_Owned_After_Transaction floatvarchar(100), Value_Transaction floatvarchar(100), Enterprise_Value floatvarchar(100), Equity_Value floatvarchar(100), Acq_CUSIP varchar(10100), Acq_prnt_CUSIP varchar(10100), Acq_Ultimate_CUSIP varchar(10100), Tgt_prnt_CUSIP varchar(10100), Tgt_Ultimate_CUSIP varchar(10100), Tgt_CUSIP varchar(10100), Acq_Primary_Ticker varchar(10100), Acq_Ultimate_Ticker varchar(10100), Tgt_Primary_Ticker varchar(10100), Tgt_Ultimate_Ticker varchar(10), Tgt_Ultimate_Ticker2 varchar(10100), Acq_NAIC varchar(10100), Acq_Ultimate_NAIC varchar(10100), Tgt_Primary_NAIC varchar(10100), Tgt_Ultimate_NAIC varchar(10100), NBid varchar(10100), Status varchar(10100), Value_Est varchar(10100), Value_Amended_Flag varchar(10100), Date_Announced_Estimated varchar(10100), Consideration_Structure varchar(10100), NConsid_off varchar(10100), NConsid_Sought varchar(10100), Consid_Structure varchar(10100), Pc_Cash varchar(10100), Pc_Other varchar(10100), Pc_Stock varchar(10100), Pc_Unknown varchar(10100), Acq_FullName varchar(10100), Tgt_Name2 varchar(30100), Acq_City varchar(30100), Tgt_City varchar(30100), Acq_Zip varchar(10100), Tgt_Zip varchar(10100), Acq_St varchar(10100), Tgt_St varchar(10100), Currency varchar(10100), Tgt_Bankrupt varchar(10100), Chlng_Deal varchar(10100), Debt_Restructuring varchar(10100), RecapDefense varchar(10100), Government_Owned_Involvement_Flag varchar(10100), Joint_Venture varchar(10100), Restructuring varchar(10100), Acq_LBO_firm varchar(10100), LBO varchar(10100), IPO_Flag varchar(10100), Tgt_LBO_firm varchar(10100), Merger_Equals varchar(10100), Reverse_Takeover varchar(10100), Deal_was_Rumor varchar(10100), Acq_is_a_White_Knight varchar(10100), White_Knight_Defense varchar(10100), Back_End_Defense varchar(10100), FlipOver_Defense varchar(10100), Voting_Plan_Defense varchar(10100), Poison_Pill varchar(10100), Creeping_Acquisition varchar(10100), Repurchase_Defense varchar(10100), Pacman_Defense varchar(10100), Lockup_FlagY_N varchar(10100), Tgt_Lockup varchar(10100), Greenmail varchar(10100), Asset_Lockup varchar(10100), Scorched_Earth_Defense varchar(10100), SelfTender_Defense varchar(10100), Stock_Lockup varchar(10100), Defense varchar(10100), White_Squire varchar(10100), Acq_Includes_Employees varchar(10100), Acq_Includes_an_ESOP varchar(10100), Sig_Family_Ownership_Tgt varchar(10100), Acq_Lockup varchar(10100), Financial_Acq varchar(10100), Step_Spinoff varchar(10100), Acq_Includes_Mgmt varchar(10100), Open_Market_Purchases varchar(10100), Proxy_Fight varchar(10100), Purpose_Code varchar(10100), Related_Deals varchar(10100), Foreign_Provider_Funds varchar(10100), Stock_Swap varchar(10100), Asset_Swap_Flag varchar(10100), Sweep_the_Street varchar(10100), SelfTender varchar(10100), Tender_offer varchar(10100), Unsolicited varchar(10100), Acq_TermFee varchar(10100), Tgt_TermFee varchar(10100), Forced_vote_provisions_FlagY_N varchar(10100), Walkaway varchar(10100), Acq_Ultimate_Add1 varchar(50100), Acq_Ultimate_Add2 varchar(50100), Tgt_Ultimate_Add1 varchar(50100), Tgt_Ultimate_Add2 varchar(50100), Acq_stockEx varchar(10100), Tgt_stockEx varchar(10100), Tgt_Net_Sales varchar(10100), Tgt_Net_Assets varchar(10100), Tgt_Total_Assets varchar(10100), Tgt_Common_Equity varchar(10100), Tgt_BVpersh_LTMUS varchar(10100), Tgt_IntangibleA varchar(10100), Tgt_RD varchar(10100), Tgt_Tot_liab varchar(10100)

 Few columns The column tgt_name seemed to have repeated twice in our data. To save time, I've just added 2 at the end of the column name for any such occurrence.