Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL Modify Column in a Table

#SQL Server

ALTER TABLE Customers
ALTER COLUMN age VARCHAR(2);

#MySQL

ALTER TABLE Customers
MODIFY COLUMN age VARCHAR(2);

#Oracle

ALTER TABLE Customers
MODIFY age VARCHAR(2);

#PostgreSQL

ALTER TABLE Customers
ALTER COLUMN age TYPE VARCHAR(2);
Source by www.sqlservertutorial.net #
 
PREVIOUS NEXT
Tagged: #SQL #Modify #Column #Table
ADD COMMENT
Topic
Name
9+4 =