Without droping this table , anyother way just to mention in right order for new column ?

how to find the statistics name ???

What i have to enter at Statistics name ..

i tried by column name and _w.. also

Gila .. i am here only .. u will get my reply soonly.. here it shows 250 entries... table having 1024 columns...

AUTO 00NULL

_WA_s_TRX_TIMESTAMP_7227B923410485856NULL

_WA_s_CODE_7227B923510485856NULL

_WA_s_USER_ID_7227B923910485856NULL

_WA_s_sKEY_7227B923108388704NULL

_WA_s_DQ_CD_7227B9231210485856NULL

_WA_s_RECORD_TYPE_7227B9231510485856NULL

_WA_s_DRV_1_NUMBER_7227B9231610485856NULL

_WA_s_VEH_1_MODEL_YEAR_7227B9231710485856NULL

_WA_s_NI_LAST_NAME_7227B9231810485856NULL

I have not created any index on table.. also if see by using sp_help there is no indexes ... but only thing is entry is available in the sysindex.. if...

I am sorry for posting two time the same topic.. this is first time i am posting..

i tried to delete .. however i dont have rights...

error throws ...

Ad hoc...

after executing

dbcc checkdb

DBCC results for 'AUTO'.

There are 154783 rows in 154784 pages for object 'AUTO'.

DBCC results for 'sysindexes'.

There are 1856 rows in 112 pages for object 'sysindexes'.

Also executed...