January 7, 2010 at 9:02 am
I am loading data into plenty of tables . few tables have indexes on it .
I am want to remove the index and laod the data and then enable the index.
for now i am manually going and disabling the index , and again enabling it .
but i have like 200 - 500 tables
Is there any script which would do this
How do i find the indexes in a database
rather than using sp_helpindex for each table
January 7, 2010 at 9:27 am
How do i find the indexes in a database
rather than using sp_helpindex for each table
You can do something like this:
select so.name as tablename,si.name as indexname from sys.indexes si
inner join sys.objects so on si.object_id=so.object_id
where so.type_desc='User_Table'
It will bring only the user table. You can remove the where clause if you want to include everything.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply