Alter Table Column Data Type

Posted on By David Kittell 
ALTER TABLE <schemaName>.<tableName>
ALTER COLUMN <columnName> nvarchar(200) [NULL|NOT NULL]

Example:

ALTER TABLE datatable1 Alter column datatable1column1 varchar(255) null
Originally Posted on October 10, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

Raspberry Pi – Dynamic MOTD

Posted on

Similar to UNIX – Set SSH Banner but this will update at every login incase something changes. mkdir /etc/update-motd.d cd /etc/update-motd.d touch 00-header && touch 11-server-info && touch 99-footer chmod +x /etc/update-motd.d/* rm /etc/motd ln -s /var/run/motd /etc/motd #!/bin/bash # Functions – Start # Function to convert IP Subnet Mask…

Read More

PowerShell Get All Environment Variables

Posted on

If you need to know some of the system variables that are already set you can run this script to get the values Get-Childitem env: gci env: | sort name Once you know what variable you want you can do something like this Write-Host "Computer:`t" $env:COMPUTERNAME Write-Host "Domain:`t" $env:USERDOMAIN All…

Read More

Bash – CSV Row / Array To Single Column

Posted on

cat environments.txt| sed "s|,|\n|g"| sed ‘s|"||g’ | sed ‘s/^[ \t]*//;s/[ \t]*$//’ Originally Posted on October 19, 2021Last Updated on August 17, 2024 All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested…

Read More