|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 18th, 2005, 06:51 AM
|
|||
|
|||
|
Alter Column
I have a table with a name COMPANY that has a column "NAME Varchar(25)". I´m trying to alter it to be Varchar(50). How can I do alter it using SQL ?? And I´m trying to alter using IBExpert but it´s giving me this error:
This operation is not defined for system tables. unsucessful metadata update. Why do I get this error ??? Thanx
|
|
#3
August 19th, 2005, 06:35 AM
|
||||
|
||||
|
From FireBird Language Reference:
Code:
ALTER TABLE
Changes a table by adding, dropping, or modifying columns or integrity constraints.
Available in SQL, DSQL, and isql.
Syntax ALTER TABLE table <operation> [, <operation> …];
<operation> = {ADD <col_def>
| ADD <tconstraint>
| ALTER [COLUMN] column_name <alt_col_clause>
| DROP col
| DROP CONSTRAINT constraint}
Posting correct syntax: "alter table MYTABLE alter MYCOLUMN varchar(50);"
__________________
If i've been helpful, please add to my reputation. My unfinished site: http://www.dever.ro Last edited by SilverDB : August 19th, 2005 at 06:39 AM.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Alter Column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
