| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/_Archive/CST1600/ |
Upload File : |
<?
// CST1600/Lesson1-1_Keywords.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
$thisFile=__FILE__; $thisLine=__LINE__; include('application.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/courseInfo.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('classInfo.phpinc');
$assignmentNumber = "1-1";
$assignmentType = "Lesson";
$assignmentTitle = "Creating Database Tables - Keyword list";
//$evaluationNumber = "";
$evaluationType = "Lab";
//$evaluationTitle = "";
if (!isset($evaluationTitle) || $evaluationTitle == "") { $evaluationTitle = $assignmentTitle; }
if (!isset($evaluationNumber) || $evaluationNumber == "") { $evaluationNumber = $assignmentNumber; }
if (strlen($assignmentNumber) == 1) { $assignmentName = $assignmentType."0".$assignmentNumber; } else { $assignmentName = $assignmentType.$assignmentNumber; }
if (strlen($evaluationNumber) == 1) { $evaluationName = $evaluationType."0".$evaluationNumber; } else { $evaluationName = $evaluationType.$evaluationNumber; }
if ($evaluationTitle != '') $evaluationTitle = ': '.$evaluationTitle;
$title = $assignmentType." ".$assignmentNumber.": ".$assignmentTitle;
$levelChapter = split('-',$assignmentNumber);
$title = $assignmentType." ".$assignmentNumber.": ".$assignmentTitle;
$headTitle = '_CST_ - '.$courseNumber.' '.$courseTitle.' - '.$title;
$pageTitle = $courseNumber.' '.$courseTitle.'<br>'.$title;
$pageMenu = 'Course/courseMenu.phpinc';
$smallTitle = true;
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('Login/authenticate.phpinc');
$sectionTitle = $courseNumber.' '.$courseTitle.' - '.$title;
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionHeader.phpinc');
?>
<p>
<fieldset><legend>Keyword list: A list of SQL keywords to stay away from when naming databases, tables, queries, forms, reports, and fields.</legend><span class="normal">
a
abort
abs
absolute
accept
access
acos
acquire
action
activate
ada
add
addform
admin
after
aggregate
alias
all
allocate
alphanumeric
alter
an
analyze
and
any
append
application
archive
archivelog
are
array
arraylen
as
asc
ascii
asensitive
asin
assert
assertion
assign
assistant
at
atan
audit
authorization
autoincrement
avg
avgu
<br />
backup
base_table
become
before
begin
between
bigint
binary
binary_integer
bind
binding
bit
bit_length
blob
block
body
boolean
both
breadth
break
breakdisplay
browse
bufferpool
bulk
by
byref
byte
<br />
cache
call
callproc
cancel
capture
cascade
cascaded
case
cast
catalog
ccsid
ceiling
change
char
char_base
char_length
character
character_length
chartorowid
check
checkpoint
chr
class
cleanup
clear
clearrow
clob
close
cluster
clustered
clusters
coalesce
cobol
colauth
colgroup
collate
collation
collection
column
columns
command
comment
commit
committed
compactdatabase
compile
completion
complex
compress
compute
concat
condition
confirm
connect
connection
constant
constraint
constraints
constructor
container
contains
containstable
contents
continue
controlfile
controlrow
convert
copy
corresponding
cos
count
counter
countu
crash
create
createdatabase
createfield
creategroup
createindex
createobject
createproperty
createrelation
createtabledef
createuser
createworkspace
cross
cube
currency
current
current_date
current_path
current_role
current_time
current_timestamp
current_user
currentuser
currval
cursor
cvar
cycle
<br />
data
data_base
database
databases
datafile
datahandler
datapages
date
datetime
day
day_hour
day_microsecond
day_minute
day_second
dayofmonth
dayofweek
dayofyear
days
dba
dbcc
dbspace
deallocate
debugoff
debugon
dec
decimal
declaration
declare
decode
default
deferrable
deferred
define
definition
degrees
delay
delayed
delete
deleterow
delta
deny
depth
deref
desc
describe
description
descriptor
destroy
destructor
deterministic
dhtype
diagnostics
dictionary
digits
direct
disable
disallow
disconnect
disk
dismount
display
dispose
distinct
distinctrow
distribute
distributed
div
do
document
domain
double
down
drop
dual
dummy
dump
dynamic
<br />
each
echo
editproc
else
elseif
elsif
enable
enclosed
end
end-exec
enddata
enddisplay
endexec
endforms
endif
endloop
endselect
endwhile
entry
equals
eqv
erase
errlvl
error
errorexit
escape
escaped
events
every
except
exception
exception_init
exceptions
exclude
excluding
exclusive
exec
execute
exists
exit
exp
explain
explicit
extent
external
externally
extract
<br />
false
fetch
field
fieldproc
fields
file
fillcache
fillfactor
finalize
first
float
float4
float8
floor
floppy
flush
for
force
foreign
form
formdata
forminit
forms
fortran
found
free
freelist
freelists
freetext
freetexttable
from
full
fulltext
function
<br />
general
generic
get
getcurrentconnection
getform
getobject
getoper
getoption
getrow
global
go
goto
gotopage
grant
granted
graphic
greatest
group
grouping
groups
guid
<br />
hash
having
help
helpfile
high_priority
holdlock
host
hour
hour_microsecond
hour_minute
hour_second
hours
<br />
identified
identity
identity_insert
identitycol
idle
ieeedouble
ieeesingle
if
ifnull
ignore
iimessage
iiprintf
immediate
imp
import
in
include
including
increment
index
indexes
indexpages
indicator
infile
initcap
initial
initialize
initially
initrans
inittable
inner
inout
input
insensitive
insert
insertrow
inserttext
instance
instr
int
int1
int2
int3
int4
int8
integer
integer1
integer2
integer4
integrity
interface
intersect
interval
into
is
isolation
iterate
<br />
join
<br />
key
keys
keywords
kill
<br />
label
language
large
last
lastmodified
lateral
layer
leading
least
leave
left
length
less
level
like
limit
limited
lineno
lines
link
list
lists
load
loadtable
local
localtime
localtimestamp
locate
locator
lock
locksize
log
logfile
logical
logical1
long
longbinary
longblob
longint
longtext
loop
low_priority
lower
lpad
ltrim
lvarbinary
lvarchar
<br />
macro
main
manage
manual
map
match
max
maxdatafiles
maxextents
maxinstances
maxlogfiles
maxloghistory
maxlogmembers
maxtrans
maxvalue
mediumblob
mediumint
mediumtext
memo
menuitem
message
microsecond
microseconds
middleint
min
minextents
minus
minute
minute_microsecond
minute_second
minutes
minvalue
mirrorexit
mlslabel
mod
mode
modifies
modify
module
money
month
months
mount
move
<br />
name
named
names
national
natural
nchar
nclob
new
newpassword
next
nextval
nheader
no
no_write_to_binlog
noarchivelog
noaudit
nocache
nocheck
nocompress
nocycle
noecho
nomaxvalue
nominvalue
nonclustered
none
noorder
noresetlogs
normal
nosort
not
note
notfound
notrim
nowait
null
nullif
nullvalue
number
number_base
numeric
numparts
nvl
<br />
obid
object
octet_length
odbcinfo
of
off
offline
offsets
old
oleobject
on
once
online
only
open
opendatasource
openquery
openrecordset
openrowset
openxml
operation
optimal
optimize
option
optionally
or
oracle
order
ordinality
orientation
others
out
outer
outfile
output
over
overlaps
own
owneraccess
<br />
package
pad
page
pages
parallel
parameter
parameters
part
partial
partition
pascal
path
pctfree
pctincrease
pctindex
pctused
percent
perm
permanent
permit
pi
pipe
pivot
plan
pli
position
positive
postfix
power
pragma
precision
prefix
preorder
prepare
preserve
primary
print
printscreen
prior
priqty
private
privileges
proc
procedure
processexit
profile
program
prompt
property
public
purge
putform
putoper
putrow
<br />
qualification
quarter
queries
query
quit
quota
<br />
radians
raise
raiserror
rand
range
raw
read
reads
readtext
real
recalc
reconfigure
record
recordset
recover
recursive
redisplay
ref
references
referencing
refresh
refreshlink
regexp
register
registerdatabase
relation
relative
release
relocate
remove
remr
rename
repaint
repairdatabase
repeat
repeatable
repeated
replace
replicate
replication
report
reports
requery
require
reset
resetlogs
resource
restore
restrict
restricted
result
resume
retrieve
return
returns
reuse
reverse
revoke
right
rlike
role
roles
rollback
rollup
routine
row
rowcount
rowguidcol
rowid
rowidtochar
rowlabel
rownum
rows
rowtype
rpad
rrn
rtrim
rule
run
runtimestatistics
<br />
save
savepoint
schedule
schema
schemas
scn
scope
screen
scroll
scrolldown
scrollup
search
second
second_microsecond
seconds
secqty
section
segment
select
sensitive
separate
separator
sequence
serializable
service
session
session_user
set
setfocus
setoption
sets
setuser
share
shared
short
show
shutdown
sign
simple
sin
single
size
sleep
smallint
snapshot
some
soname
sort
soundex
space
spatial
specific
specifictype
sql
sql_big_result
sql_calc_found_rows
sql_small_result
sqlbuf
sqlca
sqlcode
sqlerrm
sqlerror
sqlexception
sqlstate
sqlwarning
sqrt
ssl
start
starting
state
statement
statement_id
static
statistics
stddev
stdev
stdevp
stogroup
stop
storage
storpool
straight_join
string
structure
submenu
subpages
substr
substring
subtype
successful
suffix
sum
sumu
switch
synonym
syscat
sysdate
sysfun
sysibm
sysstat
system
system_user
systime
systimestamp
<br />
tabauth
table
tabledata
tabledef
tabledefs
tableid
tables
tablespace
tan
tape
task
temp
temporary
terminate
terminated
text
textsize
than
then
thread
time
timeout
timestamp
timezone_hour
timezone_minute
tinyblob
tinyint
tinytext
to
top
tpe
tracing
trailing
tran
transaction
transform
translate
translation
treat
trigger
triggers
trim
true
truncate
tsequal
type
<br />
uid
uncommitted
under
undo
union
unique
unknown
unlimited
unloadtable
unlock
unnest
unsigned
until
up
update
updatetext
upgrade
upper
usage
use
user
using
utc_date
utc_time
utc_timestamp
uuid
<br />
validate
validproc
validrow
value
values
var
varbinary
varchar
varchar2
varcharacter
variable
variables
variance
varp
varying
vcat
version
view
views
volumes
<br />
waitfor
week
when
whenever
where
while
with
without
work
workspace
write
writetext
<br />
xor
<br />
year
year_month
years
yes
yesno
<br />
zerofill
zone
</span></fieldset>
<?
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/ExampleFlles.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('ReferencesResources.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionFooter.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
?>