|
Posted by Peter on 04/16/06 22:23
>
> CREATE TABLE dbo.t1 (x INT NOT NULL PRIMARY KEY, z1 INT NULL);
> GO
> CREATE VIEW dbo.v1 AS
> SELECT * FROM dbo.t1
> GO
> ALTER TABLE dbo.t1 DROP COLUMN z1 ;
> ALTER TABLE dbo.t1 ADD z2 INT ;
> GO
> EXEC dbo.sp_recompile 'dbo.v1' ;
> /* Notice that the second column still exists as Z1 in the view */
> SELECT x,z1 FROM dbo.v1 ;
>
> --
O that is bad!!! I gonne test that immidiatly tuesday. Is it different when
naming the columns?
Navigation:
[Reply to this message]
|