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 – Wi-Fi & Ethernet Switch

Posted on

Sometimes you need to turn off Wi-Fi and turn on Ethernet and vice-versa NOTE: Important to know what your configuration is. sudo ifconfig en6 up && sudo ifconfig en0 down sudo ifconfig en6 down && sudo ifconfig en0 up All information on this site is shared with the intention to…

Read More

Draw an arrow within a box

Posted on

Imports System.Drawing Imports System.Drawing.Drawing2D Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub Private Sub Form1_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles MyBase.Paint ‘ Create pen. Dim blackPen As New Pen(Color.Black, 3) ‘ Create triangle. Dim point1 As New Point(15,…

Read More

Install CSVKit

Posted on

I personally use Ubuntu, if you don’t the commands may be slightly different. To install: apt-get –assume-yes update && apt-get –assume-yes upgrade && apt-get –assume-yes autoremove apt-get –assume-yes install python-dev python-pip python-setuptools build-essential pip install –upgrade setuptools pip install –upgrade csvkit Originally Posted on May 14, 2015Last Updated on October…

Read More