视图小问题

CREATE TABLE T1 (a INT ,b INT)

INSERT INTO dbo.T1
        ( a, b )
VALUES  ( 1,  2   ),(3,4)
go
CREATE VIEW V1 AS SELECT * FROM dbo.T1 GO


DROP TABLE T1 ;
GO

CREATE TABLE T1 (c INT ,d INT)
GO

INSERT INTO dbo.T1
        ( c, d )
VALUES  ( 1,  2   ),(3,4)

SELECT name,column_id FROM sys.columns WHERE object_id = object_id(‘V1‘)


name  column_id
--------------------------- -----------
a                                1
b                                 2