MySQL中修改数据表的名字的命令是()。A、Alter table tablename rename to new_nameB、Alter table tablename rename new_nameC、Rename tablename to newnameD、Rename tablename newname

MySQL中修改数据表的名字的命令是()。

  • A、Alter table tablename rename to new_name
  • B、Alter table tablename rename new_name
  • C、Rename tablename to newname
  • D、Rename tablename newname

相关考题:

下列命令将“产品”表的“名称”字段名修改为“产品名称”:ALTER TABLE产品RENAME______名称TO产品名称

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?() A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

如下命令将“产品”表的“名称”字段名修改为“产品名称”ALLER TABLE产品RENAME【 】名称TO产品名称

Delete form. tablename与TRUNCATE table tablename的区别

将Student.dbf表中jg字段的名称改为籍贯,如下选项中正确的SQL语句是A)ALTER TABLE student ALTER COLUMN jg TO籍贯B)ALTER TABLE student ADD籍贯C(10)C)ALTER TABLE student RENAME jg TO籍贯D)ALTER TABLE student RENAME jg籍贯

将Student.dbf表中jg字段的名称改为籍贯,如下选项中正确的SQL语句是( )。A.ALTER TABLE student ALTER COLUMN jg TO 籍贯B.ALTER TABLE student ADD 籍贯 C(10)C.ALTER TABLE student RENAME jg TO 籍贯D.ALTER TABLE student RENAME jg 籍贯

在SQL的数据定义功能中,下列命令格式可以用来修改表中字段名的是A.CREATE TABLE数据表名NAME...B.ALTER TABLE数据表名ALTER字段名...C.ALTER TABLE数据表名RENAME COLUMN字段名TO...D.ALTER TABLE数据表名ALTER字段名SET DEFAULT...

创建表的命令为( )。A.rename tableB.drop tableC.Create tableD.alter table

数据库xscj中有xs表,下列( )语句可以执行。A.rename table xs to xs1B.rename database xscj to xscj1C.use xscjD.use xs

:在SQL的数据定义功能中,下列命令格式可以用来修改表中字段名的是A)CREATE TABLE 数据表名 NAME...B)ALTER TABLE 数据表名 ALTER字段名...C)ALTER TABLE 数据表名 RENAME COLUMN字段名 TO...D)ALTER TABLE 数据表名 ALTER 字段名 SET DEFAULT...

下列命令将“产品”表的“名称”字段名修改为“产品名称”:ALTER TABLE产品RENAME__________名称T0产品名称

语句“Rename table xs to xsqk”是将xs表重命名为xsqk。

创建表的命令为()A、Create tableB、rename tableC、alter tableD、drop table

修改表的命令为()A、Create tableB、rename tableC、alter tableD、drop table

数据库xscj中有xs表,下列()语句可以执行。A、use xscjB、use xsC、rename table xs to xs1D、rename database xscj to xscj1

数据库xscj中有xs表,下列哪些语句可以执行()A、use xscjB、use xsC、rename table xs to xs1D、rename database xscj to xscj1

修改本地视图使用的命令是()A、CREATE SQL VIEWB、MODIFY VIEWC、RENAME VIEWD、DELETE VIEW

下面哪个命令不属于数据定义语言()A、alter table…B、drop index…C、create view…D、update tablename…

设有一个表rsda,该表有一个名为zc的字段。如果要把字段名zc改为zhicheng,可以使用下列命令()A、ALTER TABLE rsda RENAME COLUMN zc TO zhichengB、ALTER TABLE rsda RENAME FIELD zc TO zhichengC、ALTER TABLE rsda COLUMN RENAME zc TO zhichengD、ALTER TABLE rsda FIELD zc RENAME TO zhicheng

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A、Drop the table.B、Partition the tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()  A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.

假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”,可以使用()语句。A、ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGEB、ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGEC、RENAME TABLE CUSTOMER TO CUSTOMER_CHANGED、RENAME TABLE CUSTOMER CUSTOMER_CHANGE

ExcelUtil的params参数中必须要传的是()A、tableName、columnCaptionsB、tableName、columnNamesC、columnCaptions、columnNamesD、tableName、filter

判断题语句“Rename table xs to xsqk”是将xs表重命名为xsqk。A对B错

多选题MySQL中修改数据表的名字的命令是()。AAlter table tablename rename to new_nameBAlter table tablename rename new_nameCRename tablename to newnameDRename tablename newname

单选题假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”,可以使用()语句。AALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGEBALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGECRENAME TABLE CUSTOMER TO CUSTOMER_CHANGEDRENAME TABLE CUSTOMER CUSTOMER_CHANGE

单选题设有一个表rsda,该表有一个名为zc的字段。如果要把字段名zc改为zhicheng,可以使用下列命令()AALTER TABLE rsda RENAME COLUMN zc TO zhichengBALTER TABLE rsda RENAME FIELD zc TO zhichengCALTER TABLE rsda COLUMN RENAME zc TO zhichengDALTER TABLE rsda FIELD zc RENAME TO zhicheng