mssql.php 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261
  1. <?php /* vim: se et ts=4 sw=4 sts=4 fdm=marker tw=80: */
  2. /**
  3. * Copyright (c) 1998-2010 Manuel Lemos, Tomas V.V.Cox,
  4. * Stig. S. Bakken, Lukas Smith, Igor Feghali
  5. * All rights reserved.
  6. *
  7. * MDB2_Schema enables users to maintain RDBMS independant schema files
  8. * in XML that can be used to manipulate both data and database schemas
  9. * This LICENSE is in the BSD license style.
  10. *
  11. * Redistribution and use in source and binary forms, with or without
  12. * modification, are permitted provided that the following conditions
  13. * are met:
  14. *
  15. * Redistributions of source code must retain the above copyright
  16. * notice, this list of conditions and the following disclaimer.
  17. *
  18. * Redistributions in binary form must reproduce the above copyright
  19. * notice, this list of conditions and the following disclaimer in the
  20. * documentation and/or other materials provided with the distribution.
  21. *
  22. * Neither the name of Manuel Lemos, Tomas V.V.Cox, Stig. S. Bakken,
  23. * Lukas Smith, Igor Feghali nor the names of his contributors may be
  24. * used to endorse or promote products derived from this software
  25. * without specific prior written permission.
  26. *
  27. * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  28. * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  29. * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
  30. * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
  31. * REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
  32. * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
  33. * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
  34. * OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
  35. * AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
  36. * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY
  37. * WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
  38. * POSSIBILITY OF SUCH DAMAGE.
  39. *
  40. * PHP version 5
  41. *
  42. * @category Database
  43. * @package MDB2_Schema
  44. * @author David Coallier <davidc@php.net>
  45. * @license BSD http://www.opensource.org/licenses/bsd-license.php
  46. * @version SVN: $Id$
  47. * @link http://pear.php.net/packages/MDB2_Schema
  48. */
  49. // {{{ $GLOBALS['_MDB2_Schema_Reserved']['mssql']
  50. /**
  51. * Has a list of all the reserved words for mssql.
  52. *
  53. * @package MDB2_Schema
  54. * @category Database
  55. * @access protected
  56. * @author David Coallier <davidc@php.net>
  57. */
  58. $GLOBALS['_MDB2_Schema_Reserved']['mssql'] = array(
  59. 'ADD',
  60. 'CURRENT_TIMESTAMP',
  61. 'GROUP',
  62. 'OPENQUERY',
  63. 'SERIALIZABLE',
  64. 'ALL',
  65. 'CURRENT_USER',
  66. 'HAVING',
  67. 'OPENROWSET',
  68. 'SESSION_USER',
  69. 'ALTER',
  70. 'CURSOR',
  71. 'HOLDLOCK',
  72. 'OPTION',
  73. 'SET',
  74. 'AND',
  75. 'DATABASE',
  76. 'IDENTITY',
  77. 'OR',
  78. 'SETUSER',
  79. 'ANY',
  80. 'DBCC',
  81. 'IDENTITYCOL',
  82. 'ORDER',
  83. 'SHUTDOWN',
  84. 'AS',
  85. 'DEALLOCATE',
  86. 'IDENTITY_INSERT',
  87. 'OUTER',
  88. 'SOME',
  89. 'ASC',
  90. 'DECLARE',
  91. 'IF',
  92. 'OVER',
  93. 'STATISTICS',
  94. 'AUTHORIZATION',
  95. 'DEFAULT',
  96. 'IN',
  97. 'PERCENT',
  98. 'SUM',
  99. 'AVG',
  100. 'DELETE',
  101. 'INDEX',
  102. 'PERM',
  103. 'SYSTEM_USER',
  104. 'BACKUP',
  105. 'DENY',
  106. 'INNER',
  107. 'PERMANENT',
  108. 'TABLE',
  109. 'BEGIN',
  110. 'DESC',
  111. 'INSERT',
  112. 'PIPE',
  113. 'TAPE',
  114. 'BETWEEN',
  115. 'DISK',
  116. 'INTERSECT',
  117. 'PLAN',
  118. 'TEMP',
  119. 'BREAK',
  120. 'DISTINCT',
  121. 'INTO',
  122. 'PRECISION',
  123. 'TEMPORARY',
  124. 'BROWSE',
  125. 'DISTRIBUTED',
  126. 'IS',
  127. 'PREPARE',
  128. 'TEXTSIZE',
  129. 'BULK',
  130. 'DOUBLE',
  131. 'ISOLATION',
  132. 'PRIMARY',
  133. 'THEN',
  134. 'BY',
  135. 'DROP',
  136. 'JOIN',
  137. 'PRINT',
  138. 'TO',
  139. 'CASCADE',
  140. 'DUMMY',
  141. 'KEY',
  142. 'PRIVILEGES',
  143. 'TOP',
  144. 'CASE',
  145. 'DUMP',
  146. 'KILL',
  147. 'PROC',
  148. 'TRAN',
  149. 'CHECK',
  150. 'ELSE',
  151. 'LEFT',
  152. 'PROCEDURE',
  153. 'TRANSACTION',
  154. 'CHECKPOINT',
  155. 'END',
  156. 'LEVEL',
  157. 'PROCESSEXIT',
  158. 'TRIGGER',
  159. 'CLOSE',
  160. 'ERRLVL',
  161. 'LIKE',
  162. 'PUBLIC',
  163. 'TRUNCATE',
  164. 'CLUSTERED',
  165. 'ERROREXIT',
  166. 'LINENO',
  167. 'RAISERROR',
  168. 'TSEQUAL',
  169. 'COALESCE',
  170. 'ESCAPE',
  171. 'LOAD',
  172. 'READ',
  173. 'UNCOMMITTED',
  174. 'COLUMN',
  175. 'EXCEPT',
  176. 'MAX',
  177. 'READTEXT',
  178. 'UNION',
  179. 'COMMIT',
  180. 'EXEC',
  181. 'MIN',
  182. 'RECONFIGURE',
  183. 'UNIQUE',
  184. 'COMMITTED',
  185. 'EXECUTE',
  186. 'MIRROREXIT',
  187. 'REFERENCES',
  188. 'UPDATE',
  189. 'COMPUTE',
  190. 'EXISTS',
  191. 'NATIONAL',
  192. 'REPEATABLE',
  193. 'UPDATETEXT',
  194. 'CONFIRM',
  195. 'EXIT',
  196. 'NOCHECK',
  197. 'REPLICATION',
  198. 'USE',
  199. 'CONSTRAINT',
  200. 'FETCH',
  201. 'NONCLUSTERED',
  202. 'RESTORE',
  203. 'USER',
  204. 'CONTAINS',
  205. 'FILE',
  206. 'NOT',
  207. 'RESTRICT',
  208. 'VALUES',
  209. 'CONTAINSTABLE',
  210. 'FILLFACTOR',
  211. 'NULL',
  212. 'RETURN',
  213. 'VARYING',
  214. 'CONTINUE',
  215. 'FLOPPY',
  216. 'NULLIF',
  217. 'REVOKE',
  218. 'VIEW',
  219. 'CONTROLROW',
  220. 'FOR',
  221. 'OF',
  222. 'RIGHT',
  223. 'WAITFOR',
  224. 'CONVERT',
  225. 'FOREIGN',
  226. 'OFF',
  227. 'ROLLBACK',
  228. 'WHEN',
  229. 'COUNT',
  230. 'FREETEXT',
  231. 'OFFSETS',
  232. 'ROWCOUNT',
  233. 'WHERE',
  234. 'CREATE',
  235. 'FREETEXTTABLE',
  236. 'ON',
  237. 'ROWGUIDCOL',
  238. 'WHILE',
  239. 'CROSS',
  240. 'FROM',
  241. 'ONCE',
  242. 'RULE',
  243. 'WITH',
  244. 'CURRENT',
  245. 'FULL',
  246. 'ONLY',
  247. 'SAVE',
  248. 'WORK',
  249. 'CURRENT_DATE',
  250. 'GOTO',
  251. 'OPEN',
  252. 'SCHEMA',
  253. 'WRITETEXT',
  254. 'CURRENT_TIME',
  255. 'GRANT',
  256. 'OPENDATASOURCE',
  257. 'SELECT',
  258. );
  259. //}}}