CREATE TABLE [T1] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[SNO] [int] NOT NULL ,
[SDate] [datetime] NOT NULL ,
[SCD] [int] NOT NULL ,
CONSTRAINT [PK_T] PRIMARY KEY CLUSTERED
(
[SNO],
[SDate],
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GOSNO和SDate是主键怎样把ID列设置成候选键我要建另外一个表引用ID列作外键CREATE TABLE [T2] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[LNO] [int] NOT NULL ,
[LDt] [datetime] NOT NULL ,
[LCD] [int] NOT NULL ,
CONSTRAINT [PK_T2] PRIMARY KEY CLUSTERED
(
[ID],
[LNO],
) ,
CONSTRAINT [FK_T2] FOREIGN KEY (ID) REFERENCES T1(ID)
) ON [PRIMARY]
GO
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[SNO] [int] NOT NULL ,
[SDate] [datetime] NOT NULL ,
[SCD] [int] NOT NULL ,
CONSTRAINT [PK_T] PRIMARY KEY CLUSTERED
(
[SNO],
[SDate],
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GOSNO和SDate是主键怎样把ID列设置成候选键我要建另外一个表引用ID列作外键CREATE TABLE [T2] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[LNO] [int] NOT NULL ,
[LDt] [datetime] NOT NULL ,
[LCD] [int] NOT NULL ,
CONSTRAINT [PK_T2] PRIMARY KEY CLUSTERED
(
[ID],
[LNO],
) ,
CONSTRAINT [FK_T2] FOREIGN KEY (ID) REFERENCES T1(ID)
) ON [PRIMARY]
GO
解决方案 »
- sqlserver2005 表字段的设计
- 存储过程里传值遇到问题,请大家指点一下!
- 请大家来讨论一下如何权衡在表中设自增列. 在哪些情况下可用可不用
- 我重装sql server后,添加同样的登录用户名再付于相同权限时会提示“user already exists"
- 数据库登陆问题
- zjcxc(邹建)--请进 JSP中用restore database
- SQL2000查询视图的疑问
- 谁能给解释解释这句程序的意思??
- 多条Insert语句插入超时问题。
- CPU占用率问题,请各位高手帮忙
- update select count 将一个表统计结果更新到另个一表中
- 创建视图时使用with check option问题
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[SNO] [int] NOT NULL ,
[SDate] [datetime] NOT NULL ,
[SCD] [int] NOT NULL ,
CONSTRAINT [PK_T] PRIMARY KEY NONCLUSTERED
(
[SNO],
[SDate]
),
CONSTRAINT U_store UNIQUE CLUSTERED (id)) ON [PRIMARY]
GO CREATE TABLE [T2] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[LNO] [int] NOT NULL ,
[LDt] [datetime] NOT NULL ,
[LCD] [int] NOT NULL ,
CONSTRAINT [PK_T2] PRIMARY KEY CLUSTERED
(
[ID],
[LNO]
) ,
CONSTRAINT FK_t1 FOREIGN KEY (id) REFERENCES t1 (id)) ON [PRIMARY]
GOdrop table t2,t1
像您写的那样建表T1之后,
对T1进行查询时会不会和以前(我写的那个建表)有区别
会不会变慢(因为索引的关系)这张T1表很需要在[SNO],[SDate]这两个字段上建立镞索引