SQL Server table-related statements

Create an SQL Server table:
Create Table [Table name]
(
[Automatic number field] int identity (1, 1) primary key,
[Field 1] nvarchar (50) Default \ 'default value \ 'null,
[Field 2] ntext null,
[Field 3] datetime,
[Field 4] Money null,
[Field 5] int default 0,
[Field 6] decimal (12, 4) default 0,
[Field 7] image null,
)

Delete table:
Drop table [Table name]

Insert data:
Insert into [Table name] (Field 1, Field 2) values (100, \ '51windows. Net \')

Delete data:
Delete from [Table name] Where [field name]> 100

Update Data:
Update [Table name] Set [Field 1] = 200, [Field 2] = \ '51windows. Net \ 'Where [Field 3] = \ 'haiwa \'

New field:
Alter table [Table name] add [field name] nvarchar (50) null

Delete field:
Alter table [Table name] Drop column [field name]

Modify Field:
Alter table [Table name] alter column [field name] nvarchar (50) null