| public alterColumn ( string $table, string $column, string $type ) : string | ||
| $table | string | the table whose column is to be changed. The table name will be properly quoted by the method. |
| $column | string | the name of the column to be changed. The name will be properly quoted by the method. |
| $type | string | the new column type. The [[getColumnType()]] method will be invoked to convert abstract column type (if any) into the physical one. Anything that is not recognized as abstract type will be kept in the generated SQL. For example, 'string' will be turned into 'varchar(255)', while 'string not null' will become 'varchar(255) not null'. |
| return | string | the SQL statement for changing the definition of a column. |
public function alterColumn($table, $column, $type)
{
return 'ALTER TABLE ' . $this->db->quoteTableName($table) . ' CHANGE ' . $this->db->quoteColumnName($column) . ' ' . $this->db->quoteColumnName($column) . ' ' . $this->getColumnType($type);
}