Home > database >  Write SQL database code
Write SQL database code

Time:10-31

Sketch the code

CodePudding user response:

What are you doing?

CodePudding user response:

What you said is built table

 


The CREATE TABLE bed sheets (
Beds char (4) NOT NULL,
State varchar (20) not NULL,
Unit price a decimal (18, 0) not NULL,
Department nchar (4),
The CONSTRAINT [number] PK_ beds PRIMARY KEY CLUSTERED
(
[bed] ASC
)

WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)

) ON the (PRIMARY)

GO


  • Related