|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
|||
|
|||
|
sorry , i know this is quite a dumb question but the command :
ALTER TABLE tablename ADD COLUMN colname INTEGER; fails . From what I know this is the standard SQL syntax , so how does this need to look in firebird ?
__________________
FreeBSD , dooing more with less since 10 years ago |
|
#2
|
|||
|
|||
|
Try:
ALTER TABLE tablename ADD colname INTEGER; Another fine example that there is no such thing as a SQL standard: Oracle: ALTER TABLE tablename ADD (colname coltype); Postgres: ALTER TABLE tablename ADD colname coltype OR ALTER TABLE tablename ADD COLUMN colname coltype; .... |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > adding a new column in FirebirdSQL . |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|