Táblák módosítása, törlése

create database AlterTableTest
on
(
   NAME = 'AlterTableTest01',
   FILENAME = 'c:\AlterTableTest.mdf'
)

use AlterTableTest
create table Table01
(
  value1 int,
  value2 varchar(20) DEFAULT 'default value'
)
insert Table01 (value1, value2) values (10, 'abc')
insert Table01 (value1) values (20)

use AlterTableTest
ALTER TABLE Table01
ADD value3 int

use AlterTableTest
insert Table01 (value1, value2, value3)
values (2654, 'xxx', 32)

use AlterTableTest
ALTER TABLE Table01
DROP COLUMN value1

use AlterTableTest
DROP TABLE Table01

use Master
DROP DATABASE AlterTableTest