Create a 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
Rename a table: (Access to rename a table, refer to the article: rename a table in Access database)
Sp_rename 'table name', 'new table name', 'object'
New constraint:
Alter table [TABLE name] add constraint name CHECK ([CONSTRAINT field] <= '2017-1-1 ')
Delete constraints:
Alter table [TABLE name] drop constraint name
Create Default Value
Alter table [TABLE name] add constraint default name: '51windows. net' FOR [field name]
Delete default value
Alter table [TABLE name] drop constraint default name