CREATE TABLE s_table_1
(
      id INT IDENTITY(1, 4) NOT NULL PRIMARY KEY CLUSTERED
    , some_data NVARCHAR(100)
);

CREATE TABLE s_table_2
(
      id INT IDENTITY(2, 4) NOT NULL PRIMARY KEY CLUSTERED
    , some_data NVARCHAR(100)
);

CREATE TABLE s_table_3
(
      id INT IDENTITY(3, 4) NOT NULL PRIMARY KEY CLUSTERED
    , some_data NVARCHAR(100)
);

CREATE TABLE s_table_4
(
      id INT IDENTITY(4, 4) NOT NULL PRIMARY KEY CLUSTERED
    , some_data NVARCHAR(100)
);

CREATE VIEW s_table AS
              SELECT * FROM dbo.s_table_1
    UNION ALL SELECT * FROM dbo.s_table_2
    UNION ALL SELECT * FROM dbo.s_table_3
    UNION ALL SELECT * FROM dbo.s_table_4;