Question

数据库大佬们求助

这个用sql语句怎么写啊

Answer 1

USE GOODS

CREATE TABLE [Order](
[Cno] [char](4) NOT NULL,
[Goodno] [char](4) NOT NULL,
[Num] [int] NULL,
CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED
(
[Cno] ASC,
[Goodno] ASC
)
)
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Order', @level2type=N'COLUMN',@level2name=N'Cno'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Order', @level2type=N'COLUMN',@level2name=N'Goodno'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订货量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Order', @level2type=N'COLUMN',@level2name=N'Num'