How do you add a new Column to an SQL DB via SQL code?
with the ALTER DATABASE DDL statement. see books online. there are a lot of options for it, and since I don't know exactly what you won't I won't try to offer you a pre-packaged script.<BR><BR><BR>j<BR>http://rtfm.atrax.co.uk/
meant to type ALTER TABLE. got distracted
ALTER TABLE CategoriesNoPix<BR>ADD COLUMN ShortDesc Text(25);<BR><BR>Theres the syntax, thx.<BR><BR>BTW, can you edit the verabage of a column name with this same Clause?<BR>
so, what do you mean by verbage in this case?
changing the name of an existing column.
why didn't you just say that in the first place?<BR><BR>no, don't think so from looking at the docs.