01.04.2011 12:24, Alex Peshkoff wrote: > Dmitry, where have you found a reference in standard tat string column > can be altered to wider one type? > What Is see in SQL2008 is:
Your copy is outdated :-) My version of 2010-10-14 says: <alter table statement> ::= ALTER TABLE <table name> <alter table action> <alter table action> ::= <add column definition> | <alter column definition> | <drop column definition> | <add table constraint definition> | <alter table constraint definition> | <drop table constraint definition> | <add system versioning clause> | <alter system versioning clause> | <drop system versioning clause> <alter column definition> ::= ALTER [ COLUMN ] <column name> <alter column action> <alter column action> ::= <set column default clause> | <drop column default clause> | <set column not null clause> | <drop column not null clause> | <add column scope clause> | <drop column scope clause> | <alter column data type clause> | <alter identity column specification> | <drop identity property clause> | <drop column generation expression clause> <alter column data type clause> ::= SET DATA TYPE <data type> Dmitry ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
