一个SQL,手头没资料,急用,谁帮我写一下

a3skite 2002-09-11 11:57:16
Sybase的改变列名的SQL怎么写?
如改Table_1的Clm_1的列名为"Clm_2"
...全文
62 8 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
wdhs 2002-09-23
  • 打赏
  • 举报
回复
EXEC sp_rename 'Table_1.Clm_1', 'Clm_2', 'COLUMN'
Ed 2002-09-11
  • 打赏
  • 举报
回复
select Clm_2 as Clm_1 from ....
kakiyawen 2002-09-11
  • 打赏
  • 举报
回复
Alter Table......
byfq 2002-09-11
  • 打赏
  • 举报
回复
ALTER TABLE [ owner .]table-name
... ADD column-definition [ column-constraint ... ]
| ADD table-constraint
| MODIFY column-definition
myclife 2002-09-11
  • 打赏
  • 举报
回复
改名:
ALTER TABLE [ owner .]table-name RENAME column-name TO new-column-name
myclife 2002-09-11
  • 打赏
  • 举报
回复
ALTER TABLE [ owner .]table-name
... ADD column-definition [ column-constraint ... ]
| ADD table-constraint
| MODIFY column-definition
| MODIFY column-name DEFAULT default-value
| ALTER column-name SET DEFAULT default-value
| ALTER column-name DROP DEFAULT
| ALTER column-name SET COMPUTE ( expression )
| ALTER column-name DROP COMPUTE
| MODIFY column-name [ NOT ] NULL
| MODIFY column-name CHECK NULL
| MODIFY column-name CHECK ( condition )
| { DELETE | DROP } column-name
| { DELETE | DROP } CHECK
| { DELETE | DROP } UNIQUE ( column-name , ... )
| { DELETE | DROP } PRIMARY KEY
| { DELETE | DROP } FOREIGN KEY role-name
| RENAME new-table-name
| RENAME column-name TO new-column-name

column-definition :
column-name data-type [ NOT NULL ] [ DEFAULT default-value ]

column-constraint :
{ UNIQUE
| PRIMARY KEY
| REFERENCES table-name [ ( column-name ) ] [ actions ]
} [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]
| CHECK ( condition )
| COMPUTE ( expression )

default-value :
string
| global variable
| number
| AUTOINCREMENT
| CURRENT DATE
| CURRENT TIME
| CURRENT TIMESTAMP
| NULL
| TIMESTAMP
| USER

table-constraint :
{ UNIQUE ( column-name , ... )
| PRIMARY KEY ( column-name , ... )
} [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]
| CHECK ( condition )
| foreign-key-constraint

foreign-key-constraint :
[ NOT NULL ] FOREIGN KEY [ role-name ] [ (column-name , ... ) ]
... REFERENCES table-name [ (column-name , ... ) ]
... [ actions ] [ CHECK ON COMMIT ]
... [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]

actions :
[ ON UPDATE action ] [ ON DELETE action ]

action :
CASCADE
| SET NULL
| SET DEFAULT
| RESTRICT

ALTER TABLE [ owner .]table-name
... REPLICATE { ON | OFF }

ice2water 2002-09-11
  • 打赏
  • 举报
回复
不可以
a3skite 2002-09-11
  • 打赏
  • 举报
回复
我是要修改数据库,而不是select数据。

34,838

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧