怎样用sql语句修改一个表的名字？

[ctrlpower]

[nononono]

什么DBMS?

MS SQL Server不支持用命令修改表名。

[peacock]

ALTER TABLE

[ctrlpower]

是sql server 7.0

peacock兄我知道用alter table 但具体的语法还请你提醒！

[Dsoul]

ALTER TABLE table
{ [ALTER COLUMN column_name
{ new_data_type [ (precision[, scale] ) ]
[ NULL | NOT NULL ]
| {ADD | DROP} ROWGUIDCOL
}
]
| ADD
{ [ <column_definition> ]
| column_name AS computed_column_expression
}[,...n]
| [WITH CHECK | WITH NOCHECK] ADD
{ <table_constraint> }[,...n]
| DROP
{ [CONSTRAINT] constraint_name
| COLUMN column
}[,...n]
| {CHECK | NOCHECK} CONSTRAINT
{ALL | constraint_name[,...n]}
| {ENABLE | DISABLE} TRIGGER
{ALL | trigger_name[,...n]}
}

这个够全吧?建议你去SQL Server BoL中去找.好像没有改变表名的.
应该建新表后将数据放入新表中.

[Dsoul]

ALTER TABLE table
{ [ALTER COLUMN column_name
{ new_data_type [ (precision[, scale] ) ]
[ NULL | NOT NULL ]
| {ADD | DROP} ROWGUIDCOL
}
]
| ADD
{ [ <column_definition> ]
| column_name AS computed_column_expression
}[,...n]
| [WITH CHECK | WITH NOCHECK] ADD
{ <table_constraint> }[,...n]
| DROP
{ [CONSTRAINT] constraint_name
| COLUMN column
}[,...n]
| {CHECK | NOCHECK} CONSTRAINT
{ALL | constraint_name[,...n]}
| {ENABLE | DISABLE} TRIGGER
{ALL | trigger_name[,...n]}
}

这个够全吧?建议你去SQL Server BoL中去找.好像没有改变表名的.
应该建新表后将数据放入新表中.

[ctrlpower]

楼上的老兄说的对！,我也是觉得好象用alter不能改变表的名字，我是想来问问，确定一下，我记得好象可以用select into 来copy表的结构及数据的，不只楼上的兄弟，知不知道？

[nononono]

select * into newtablename from oldtablename

是可以的。

但默认的状态是into到临时表，有个设置可以允许into到永久表。

[nononono]

先允许bulkcopy:

exec sp_dboption @dbname ='数据库名', @optname ='bulkcopy', @optvalue = 'true'

再：
select * into newtablename from oldtablename

[Dsoul]

还是这个问题.我突然想起这个了.可以适合几乎所有的表中对象(包括表)

可用sp_rename改表名.详细描述如下:
sp_rename [@objname =] 'object_name',
[@newname =] 'new_name'
[, [@objtype =] 'object_type']

Arguments:
[@objname =] 'object_name'
Is the current name of the user object (table, view, column, stored procedure, trigger, default, database, object, or rule) or data type. If the object to be renamed is a column in a table, object_name must be in the form table.column. If the object to be renamed is an index, object_name must be in the form table.index. object_name is nvarchar(776), with no default.
[@newname =] 'new_name'
Is the new name for the specified object. new_name must be a one-part name and must follow the rules for identifiers. newname is sysname, with no default.
[@objtype =] 'object_type'
Is the type of object being renamed. object_type is varchar(13), with a default of NULL, and can be one of these values.

具体语法是:
EXEC sp_rename '原表名', '新表名' (T-SQL)
或者在SQL Query Analyzer里面直接用
sp_rename '原表名', '新表名'
更改.

[ctrlpower]

不好意思啊，分数有点少了