Below is the table structure with data.
USE [Cascading_ddl]
GO
/****** Object: Table [dbo].[Cities] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cities](
[CityId] [int] NOT NULL,
[StateId] [int] NOT NULL,
[CityName] [varchar](100) NOT NULL,
CONSTRAINT [PK_Cities] PRIMARY KEY CLUSTERED
(
[CityId] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Countries] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Countries](
[CountryId] [int] NOT NULL,
[CountryName] [varchar](100) NOT NULL,
CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED
(
[CountryId] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[States] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[States](
[StateId] [int] NOT NULL,
[CountryId] [int] NOT NULL,
[StateName] [varchar](100) NOT NULL,
CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED
(
[StateId] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (1, 1, N'Abbeville')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (2, 1, N'Argo')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (3, 2, N'Buckeye')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (4, 2, N'Carefree')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (5, 3, N'Juneau')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (6, 3, N'Sitka')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (7, 4, N'Mumbai')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (8, 4, N'Pune')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (9, 5, N'Ahmedabad')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (10, 5, N'Gandhinagar')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (11, 6, N'Panjim')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (12, 6, N'Vasco')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (13, 7, N'Ottawa')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (14, 7, N'Port Hope')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (15, 8, N'Chandler')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (16, 8, N'Princeville')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (17, 9, N'Carman')
INSERT [dbo].[Cities] ([CityId], [StateId], [CityName]) VALUES (18, 9, N'Roblin')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (1, N'USA')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (2, N'India')
INSERT [dbo].[Countries] ([CountryId], [CountryName]) VALUES (3, N'Canada')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (1, 1, N'Alabama')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (2, 1, N'Arizona')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (3, 1, N'Alaska')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (4, 2, N'Maharashtra')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (5, 2, N'Gujarat')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (6, 2, N'Goa')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (7, 3, N'Ontario')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (8, 3, N'Quebec')
INSERT [dbo].[States] ([StateId], [CountryId], [StateName]) VALUES (9, 3, N'Manitoba')
ALTER TABLE [dbo].[Cities] WITH CHECK ADD CONSTRAINT [FK_Cities_States] FOREIGN KEY([StateId])
REFERENCES [dbo].[States] ([StateId])
GO
ALTER TABLE [dbo].[Cities] CHECK CONSTRAINT [FK_Cities_States]
GO
ALTER TABLE [dbo].[States] WITH CHECK ADD CONSTRAINT [FK_States_Countries] FOREIGN KEY([CountryId])
REFERENCES [dbo].[Countries] ([CountryId])
GO
ALTER TABLE [dbo].[States] CHECK CONSTRAINT [FK_States_Countries]
GO