· 4 years ago · Sep 08, 2021, 02:48 PM
1IF EXISTS (SELECT * FROM [PHONEBOOK].sys.foreign_keys WHERE NAME = 'FK_PERSONS_CITY_ID')
2BEGIN
3 ALTER TABLE PERSONS
4 DROP CONSTRAINT FK_PERSONS_CITY_ID;
5END
6
7IF EXISTS(SELECT * FROM [PHONEBOOK].sys.tables WHERE NAME = 'CITIES' )
8BEGIN
9 DROP TABLE [PHONEBOOK].[dbo].[CITIES]
10END
11
12CREATE TABLE [dbo].[CITIES](
13 [ID] [int] IDENTITY NOT NULL,
14 [UPDATE_COUNTER] [int] NOT NULL CONSTRAINT DF_CITIES_UPDATE_COUNTER DEFAULT 0,
15 [NAME] [nvarchar](64) NOT NULL,
16 [DISTRICT] [nvarchar](64) NOT NULL,
17
18 CONSTRAINT PK_CITIES_ID PRIMARY KEY (ID)
19)