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

Mac OSX Terminal – Create New Admin User

Posted on

#!/bin/sh # CreateAdminUser.sh # # Created by David Kittell on 12/8/17. # clear userFullName=$1 userName=$2 userPassword=$3 echo "Checking If User Exists" # List Local Users # dscl . list /Users | grep -v ‘_’ if [[ $(dscl . list /Users) =~ "$userName" ]]; then echo "User Exists" else echo "User…

Read More

Distinct For Only One Column

Posted on

name sold_price ram 2000 shyam 3000 ram 4000 hari 50000 Want: name sold_price ram 2000 shyam 3000 hari 50000 Show first reference of ram SELECT name,sold_price FROM ( SELECT ID ,name ,sold_price ,ROW_NUMBER() OVER ( PARTITION BY name ORDER BY ID ) rn FROM shop ) a WHERE rn =…

Read More