SQL statement required (ii) CREATE TABLE, modify table structure, delete table

1. Createdatabase table-which database to use, if you do not write this sentence is the default database, you can also use the mouse to select the current database using TestDB--CREATE TABLE TableName (--id represents the field name NT data type--primary key primary key--not null non-null--identity (All) initial value is 1 per self-growth 1 ID int primary key Not null identity (--unique), unique name varchar (a) not null unique) 2. DeleteTable named Drop table name 3. ModificationsTable Structure--Add column ALTER TABLE name add column name Type--delete column ALTER TABLE name drop cloumn column name--Modify column, modify column type ALTER TABLE nameAlter column Name Type

SQL statement required (ii) CREATE TABLE, modify table structure, delete table