Want to bet?
This freaked me out...
Check out the select from the view AFTER THE ALTER DROP Column...
huh?
USE Northwind
create table foo ([id] int identity, value1 varchar(20), value2 char(10));
GO
insert into foo values ('foo', 'bar');
insert into foo values ('bar', 'bar');
insert into foo values ('foo', 'foo');
GO
Create view v_foo as Select * from foo
go
select * from v_foo
GO
SELECT * INTO tmp_Foo FROM Foo
DROP TABLE Foo
GO
create table foo ([id] int identity, value1 varchar(20), value2 char(10), value3 varchar(30));
GO
SET IDENTITY_INSERT foo ON
INSERT INTO foo([id], value1, value2)
SELECT [id], value1, value2 FROM tmp_foo
SET IDENTITY_INSERT foo OFF
GO
insert into foo values (NULL, NULL, 'foobar');
select * from v_foo
select value3 from v_foo
GO
ALTER TABLE foo DROP Column value2
select * from v_foo
select * from foo
GO
DROP VIEW v_foo
DROP TABLE foo
GO
It's an undocumented feature!
Brett
8-)
Bit Bad
Posted - 06/08/2004 : 11:54:11
