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 |