Олегон,
У меня версия более старая, но все же смог открыть в РО.
Скрипт на всю базу, через Generate:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('Accounts') and o.name = 'FK_Accounts_AccountsTypes')
alter table Accounts
drop constraint FK_Accounts_AccountsTypes
go
...
/*==============================================================*/
/* Table: Accounts */
/*==============================================================*/
...
/*==============================================================*/
/* Table: AccountsTypes */
/*==============================================================*/
...
alter table Accounts
add constraint FK_Accounts_AccountsTypes foreign key (account_type_id)
references AccountsTypes (account_type_id)
go
По отдельности - Generate - Selection по одной таблице:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('Accounts') and o.name = 'FK_Accounts_AccountsTypes')
alter table Accounts
drop constraint FK_Accounts_AccountsTypes
go
if object_id('AccountsTypes', 'u') is not null
drop table AccountsTypes
go
/*==============================================================*/
/* Table: AccountsTypes */
/*==============================================================*/
create table AccountsTypes
(
account_type_id int not null,
account_type_name nvarchar(200) not null,
constraint PK_AccountsTypes primary key (account_type_id),
constraint AK_KEY_1_ACCOUNTS unique (account_type_id)
)
go
И вторая
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('Accounts') and o.name = 'FK_Accounts_AccountsTypes')
alter table Accounts
drop constraint FK_Accounts_AccountsTypes
go
if object_id('Accounts', 'u') is not null
drop table Accounts
go
/*==============================================================*/
/* Table: Accounts */
/*==============================================================*/
create table Accounts
(
account_id int not null,
account_name nvarchar(200) not null,
account_type_id int not null,
constraint PK_Accounts primary key (account_id)
)
go
alter table Accounts
add constraint FK_Accounts_AccountsTypes foreign key (account_type_id)
references AccountsTypes (account_type_id)
go
Вроде все верно, FK во втором случае есть.
