请问该如何将tni_index索引更名为teacher_index用sql语句怎么写?

Question

将tni_index索引更名为teacher_index用sql语句怎么写?

Answer 1

一个student表student表包含三个字段的学生的ID（stu_id）学生姓名（stu_name），当然ID（les_id）“CREATE TABLE [dbo的]。学生（/ stu_id。的uniqueidentifier] NOT&nbsp;NULL，stu_name [数据类型为nvarchar]（425）NOT&nbsp;NULL，les_id [为uniqueidentifier] NOT&nbsp;NULL）第二个表中的课程课，有两个字段，当然的ID（les_id）的和课程名称（les_name）CREATE TABLE [dbo的课（les_id的uniqueidentifier] NOT NULL，les_name [数据类型为nvarchar]（425）NOT NULL）< /第三个表，学生表的分数，三场场ID（les_id）的学生证（stu_id）和课程成绩（les_score）创建表[DBO]。分数（les_id的uniqueidentifier] NULL，stu_id的唯一标识符NOT NULL，les_score [INT] NOT NULL）

Answer 2

sqlserver：--更改索引名: old_indName 改为 new_indName1sp_rename&nbsp;'tabName.old_indName','new_indName','INDEX'oracle的语法：1ALTER&nbsp;INDEX&nbsp;employee_idx&nbsp;RENAME&nbsp;TO&nbsp;employee_index_Newname;Mysql：For MySQL 5.7:1ALTER&nbsp;TABLE&nbsp;tbl_name&nbsp;RENAME&nbsp;INDEX&nbsp;old_index_name&nbsp;TO&nbsp;new_index_nameFor MySQL older versions:1ALTER&nbsp;TABLE&nbsp;tbl_name&nbsp;DROP&nbsp;INDEX&nbsp;old_index_name,&nbsp;ADD&nbsp;INDEX&nbsp;new_index_name&nbsp;(...)

Answer 3

后面要加上表名格式是这样drop&nbsp;&nbsp;index&nbsp;&nbsp;&nbsp;&nbsp;索引名&nbsp;&nbsp;&nbsp;on&nbsp;&nbsp;&nbsp;&nbsp;表名

Answer 4

select * from courseselect Sname,Sage from Student where sdept = '计算机系'select * from sc where 70 <= grade and grade =>80select Sname,Sage from Student where sdept = '计算机系' and Ssex='男'

Answer 5

1,select&nbsp;*&nbsp;from 2,select&nbsp;sname,sage&nbsp;from&nbsp;student&nbsp;where&nbsp;sdept&nbsp;=&nbsp;'计算机系' 3,select&nbsp;*&nbsp;from&nbsp;sc&nbsp;where&nbsp;70&nbsp;<=&nbsp;grade&nbsp;and&nbsp;grade&nbsp;=>80 写不下去了，你就这样的格式，select&nbsp;（要查询的字段名）&nbsp;from&nbsp;（表名）&nbsp;where&nbsp;（查询条件），，，，很简单的，，