2017-3-10 SQL Server Database T--sql statement

Creating a database: Create datebase database name Note: The database name cannot be Chinese, cannot start with a number, and cannot begin with a symbol.

Delete database:drop datebase database name

Creating table:create TABLE table name

(Column name data type,

......

Set Primary key column: Primary key

Set unique columns: Unique

Set non-null: NOT NULL

Set self-increment column: Identity (1) count, 1 per increment

）

Delete tables:drop table Table name

Add column:ALTER TABLE name add column name data type

Delete column:ALTER TABLE table name drop column name

Add Data:insert into table name values (' s002 ', ' 1987-2-3 ', ' true ', 96)

Modify data:Update table name set column name = value

Delete data:Delete from table name/truncate table table name

Query data:SELECT * FROM table name

2017-3-10 SQL Server database T--sql statement