ALTER TABLE table_name
ALTER COLUMN column_name datatype;
0
0
table de modification sql
-- With check if field already exists
IF NOT EXISTS(SELECT 1 FROM sys.columns
WHERE Name = N'Email'
AND Object_ID = Object_ID(N'dbo.Customers'))
BEGIN
ALTER TABLE Customers
ADD Email varchar(255);
END
0
0
modifier le type de données dans mysql
ALTER TABLE table_name
CHANGE COLUMN column_name column_name datatype;