t2S5vAYe

1DROP TABLE IF EXISTS dbo.ObjectFormerlyATable;
2
3CREATE TABLE dbo.ObjectFormerlyATable
4(
5	ID INT IDENTITY(1,1) NOT NULL
6	CONSTRAINT PK_dbo_ObjectFormerlyATable PRIMARY KEY CLUSTERED (ID ASC)
7);
8
9INSERT INTO dbo.ObjectFormerlyATable DEFAULT VALUES;
10
11SELECT ID FROM dbo.ObjectFormerlyATable;
12
13DROP TABLE IF EXISTS dbo.ObjectFormerlyATable;
14GO
15
16CREATE OR ALTER VIEW dbo.ObjectFormerlyATable
17AS
18SELECT
19	ID=1
20;
21GO
22
23SELECT ID FROM dbo.ObjectFormerlyATable;