tsql - Are indexes on temporary tables deleted when the table is deleted? -


would following sql remove index - or have removed separately?

create table #tbl (field int)  create nonclustered index idx on #tbl (field)  drop table #tbl 

yes are. can search in mssql create index article said there:

"indexes can created on temporary table. when table dropped or session ends, indexes , triggers dropped."


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -