add pssnapin to computer all powershell session - powershell

go to
%systemroot%\System32\WindowsPowerShell\v1.0

2) Create profile.ps1 file
add following

[void][System.Reflection.Assembly]::LoadFile("C:\ProgramFiles\My.Powershell.DLL")
Add-PSSnapin -name "My.Powershell"

3) powershell global config

create powershell.exe.config file
configuration
appSettings
add key="SMTP_SERVER" value="mail.mydomain.com"
add key="email_from" value="HciPowershell@gmail.com"
add key="Working_Path" value="G:\AutoRun\"
add key="healthxhrafromemail" value="DevTeam@hciactive.com"
appSettings
configuration

rename table column using script

SP_RENAME '[datalens].[MyTable].[InOutPatientFlag]','IsInPatient','COLUMN'