changing table structure with SQL code in ASP page

Originally posted by : aztec (aztec@wanadoo.be)I have an ASP page that executes the SQL-code i put in a textarea-field. My question:What SQL-code do i use to add, remove, change a collumn from an existing table. Let's say i wanted to add a collumn with the name "title" of type nvarchar with a length of 500 to a table called "books"If anyone could help me on this i would be verry, verry gratefull

Originally posted by : Richard (richard@trinet.co.uk)Look up ALTER TABLE in BOL:ALTER TABLE books ADD title nvarchar(500) NULLTo change a column, you would need to play with temporary tables. Try using SQL EM to alter a table, and look at the script for the operation.------------aztec at 8/26/2001 10:46:20 AMI have an ASP page that executes the SQL-code i put in a textarea-field. My question:What SQL-code do i use to add, remove, change a collumn from an existing table. Let's say i wanted to add a collumn with the name "title" of type nvarchar with a length of 500 to a table called "books"If anyone could help me on this i would be verry, verry gratefull