復制代碼 代碼如下:

IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1
CREATE TABLE T1(col1 INT,col2 INT)
INSERT INTO T1(col1,col2) VALUES(1,2)
GO

復制代碼 代碼如下:

CREATE VIEW V1
AS
SELECT * FROM T1

復制代碼 代碼如下:

ALTER TABLE T1 ADD col3 INT