sql语句怎样判断索引是否存在?

select object_name(object_id) tableName,name,type_desc from sys.indexes where name='stu_index'用这个查询就可以知道数据库中是否有stu_index这个索引select object_name(object_id) tableName,name,type_desc from sys.indexes where object_name(object_id)='stu'这个查询可以查出stu表上所有的索引 收起