Home Forums SQL Server 2008 SQL Server 2008 - General Truncate table RE: Truncate table
writearjun53
Ten Centuries
Points: 1060
More actions
March 25, 2013 at 8:13 am
#1600334
select * from sys.indexes
where object_id = (select object_id from sys.objects where name = 'TableName')
using this query u can check the index that is exist on your table.
Regards,
Arjun