数据库关键字整理之——Sybase数据库

- 日理万妓 2024-03-16 11:24 25阅读 0赞

关键字是指在数据库中有意义的字，通常是数据库内部使用， 不能用于命名用户的数据对象。 有的数据库还会详细划分，例如分为关键字，候选字，甚至更详细的分类。分类的标准例如有的是绝对不可以使用，有的通过一定手段例如添加双引号可以使用。

我们为了方便统一称之为关键字，通常用户编写的对象中使用关键字会造成错误或不确定的影响，为了避免这个问题，用户应该避免使用数据库的关键字(含保留字或其他保留别名等)。

这个系列主要整理了各大数据库的关键字，可以用于建库，建表，写存储过程，函数等场景避免冲突。最后会有个脚本工具用来检查是否使用关键字。  
  
9de7bb31d0644e7393039222babfed10

欢迎收藏。

## Sybase ##

absolute action add after alias all allocate alter and any are arith\_overflow as asc assertion async at authorization avg

before begin between bit bit\_length boolean both breadth break browse bulk by

call cascade cascaded case case cast catalog char char\_convert char\_length character character\_length check checkpoint close clustered coalesce coalesce collate collation column commit completion compute confirm connect connection constraint constraints continue controlrow convert corresponding count create cross current current\_date current\_time current\_timestamp current\_user cursor cycle

data database date day dbcc deallocate dec decimal declare default deferrable deferred delete depth desc describe descriptor deterministic diagnostics dictionary disconnect disk distinct domain double drop dummy dump

each else elseif end end-exec endtran equals errlvl errordata errorexit escape except exception exclusive exec execute exists exit exp\_row\_size external extract

FALSE fetch fillfactor first float for foreign found from full func

general get global go goto grant group

having holdlock hour

identity identity\_gap identity\_insert identity\_start if ignore immediate in index indicator initially inner inout input insensitive insert install int integer intersect interval into is isolation

jar join join

key kill

language last leading leave left less level like limit lineno load local lock loop lower

match max max\_rows\_per\_page min minute mirror mirrorexit modify modify module month

names national natural nchar new new next no noholdlock nonclustered none not null nullif nullif numeric numeric\_truncation

object octet\_length of off offsets oid old on once online only open operation operators option or order others out outer output output over overlaps

pad parameters partial partition pendant perm permanent plan position precision preorder prepare preserve primary print prior private privileges proc procedure processexit protected proxy\_table public

quiesce

raiserror read readpast readtext real reconfigure recursive ref references referencing relative remove reorg replace replication reservepagegap resignal restrict return return returns returns revoke right role rollback routine row rowcount rows rule

save savepoint schema scroll search second section select sensitive sequence session\_user set setuser shared shutdown signal similar size smallint some space sql sqlcode sqlerror sqlexception sqlstate statistics stringsize stripe structure substring sum syb\_identity syb\_restree syb\_terminate system\_user

table temp temporary test textsize then there time timestamp timezone\_hour timezone\_minute to trailing tran transaction translate translation trigger trim TRUE truncate tsequal type

under union unique unknown unpartition update upper usage use user user\_option using

value values varchar variable varying view virtual visible

wait waitfor when when whenever where while with without work write writetext

year

zone