Command Behavior in Deferred Tables

Most commands work similarly on deferred tables and empty tables.

Command

Action on Deferred Table

insert

Materializes the table; execute insert

select

0 rows selected

update

0 rows affected

delete

0 rows affected

alter table

Materialize the table; execute alter table

drop table

Drop table

create view, trigger or, procedure

Creates view, trigger, or procedure

create index

Creates indexes without page allocations

drop index

Drops index

reorg subcommands

None

update statistics

None

truncate table

None

dbcc checktable

None

dbcc checkcatalog

Skips indexes on deferred tables