|
|
Browse by Tags
All Tags » data mining » tempdb (RSS)
-
Using SSMS tool you can get information on tables, indexes and filegroup information for a database, how about using a TSQL statement:
select 'table_name'=object_name(i.id)
,i.indid
,'index_name'=i.name
,i.groupid
,'filegroup'=f.name
,'file_name'=d.physical_name
,'dataspace'=s.name
from sys.sysindexes i
,sys.filegroups ...
|
|
|