[SQL] 常用語法 – create table

drop table Customer
go
CREATE TABLE Customer
(
SID int not null ,–PRIMARY KEY,
ID int not null ,
LastName varchar(30) not null,
FirstName varchar(30)
)

–#新增key值
–ALTER TABLE Customer ADD PRIMARY KEY (SID);
–ALTER TABLE Customer ADD PRIMARY KEY (SID,GroupID);

–刪除key值
ALTER TABLE CustDROP [PK_Cust]

–#建立索引
ALTER TABLE Customer
ADD CONSTRAINT PK_cust PRIMARY KEY (ID,LastName);

–#新增col
ALTER TABLE Customer ADD TT varchar(10);
SELECT * FROM Customer

–#更改col type
ALTER TABLE Customer ALTER COLUMN TT varchar(40);

–#刪除col
ALTER TABLE Customer DROP COLUMN TT;
SELECT * FROM Customer

转载请注明：XAMPP中文组官网 » [SQL] 常用語法 – create table