SQL Server 数据库:
1.查看表索引:select * from sys.sysindexes where id=OBJECT_ID('tablename');
mysql 数据库:
1.查看索引:show index from tablename
2.创建索引:create index indexname on tablename (columname);
3.删除索引:drop index indexname on talbename;
SQL Server 数据库:
1.查看表索引:select * from sys.sysindexes where id=OBJECT_ID('tablename');
mysql 数据库:
1.查看索引:show index from tablename
2.创建索引:create index indexname on tablename (columname);
3.删除索引:drop index indexname on talbename;