SQL SERVER build libraries, tables, indexes, constraints

CREATE DATABASE testgouse testgocreate TABLE UserInfo (Id int  IDENTITY PRIMARY key,name VARCHAR), age INT, Sex Bit,ad Dress VARCHAR (+)) Goalter TABLE dbo. UserInfo ADD Phone VARCHAR (one) ALTER TABLE dbo. UserInfo ADD CONSTRAINT Age_c CHECK (age>0 and age<200) CREATE nonclustered INDEX name_index on dbo. UserInfo (Name) ALTER TABLE dbo. UserInfo ADD CONSTRAINT name_fk FOREIGN KEY (name) REFERENCES CC (name)

　　

SQL SERVER build libraries, tables, indexes, constraints