Fundamentals of Database Design

请参阅以下网址：



http： //www.sqa.org.uk/e-learning/MDBS01CD/page_26.htm [ ^ ]

我根据您的要求制作了一张桌子。

复制粘贴在你的数据库中。

I have make a table according your requirement.
copy and paste in your database.

CREATE TABLE [dbo].[Mobile_Managment](
	[SrNo] [int] IDENTITY(1,1) NOT NULL,
	[itemName] [varchar](200) NULL,
	[Category] [varchar](200) NULL,
	[Company_name] [varchar](200) NULL,
	[SubCompany] [varchar](200) NULL,
	[Qty] [varchar](200) NULL,
 CONSTRAINT [PK_Mobile_Managment] PRIMARY KEY CLUSTERED 
(
	[SrNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

任何查询和信息回复

for any query and information hit to reply