SQL - Common SQL Server Commands

Friday, October 15th, 2021 | Coding
Last Modified: 2024-04-25



ALTER TABLE dbo.Employees 
ADD company VARCHAR (255) NULL;

####

Alter existing column:

ALTER TABLE Orders ALTER COLUMN shipToAddress1 VARCHAR (80);

ALTER TABLE Employees ALTER COLUMN address1 VARCHAR (80);

https://javarevisited.blogspot.com/2016/03/how-to-increase-length-of-existing-VARCHAR-column-in-SQL-Server.html#axzz7Lf1U1L2D




Input Action Output
A collection of snippets and links that have proven useful for development, programming, ColdFusion, Javascript, jQuery, PHP, Python, Dell, Minecraft, Apple, Mac, Windows, LINUX, Raspberry Pi, Adobe, CSS, and HTML.

©2024 Input Action Output