select name from syscolumns where id=object_id('表名') order by name
创建索引
Select col1,col3 from table1 where col2 = 'value'.
Create index indexname1 on table1(col2,col1,col3).
select name from syscolumns where id=object_id('表名') order by name
创建索引
Select col1,col3 from table1 where col2 = 'value'.
Create index indexname1 on table1(col2,col1,col3).