-
Add fields to a table?!
I'm quite new to SQL-programming.
I know how to create a table, with certain fields.
My question is: Is it possible to add new fields to an existing table after you've created it, or do you have to make a completely new table?!
I know about the UPDATE - SET, but those only changes the values in the table. I wan't to change the properties of the table in an easy way!
/Erik
-
ALTER TABLE table1
ADD COLUMN ...
see BOL for syntax
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|