exec SP_Rename 'tablename.oldcolumnname','newcolumname','Column' this proc works fine but can we write our own script