|
The SQL editor used
in AdeptSQL
Diff has a customizable set of
"templates" which speed up typing by expanding short abbreviations
into one of the commonly used SQL constructions.
To use a template, type
its abbreviation (e.g. "t" for 'table') and then press
[Ctrl-J].
Below is the list of templates predefined in the editor, the '|'
indicating the caret position after expanding the template. You can
change or add templates at any time by using the
Editor Options
Dialog.
|
Abbrev.
|
Expanded
to:
|
|
t
|
create
table | (
);
|
|
at
|
alter
table | add ;
|
|
dt
|
drop
table |;
|
|
i
|
create
index | on xx(yyy);
|
|
di
|
drop
index |;
|
|
v
|
create
view | as
select
*
from
X
where
Y;
|
|
fk
|
foreign
key (|) references
X(Y)
|
|
pk
|
primary
key (|)
|
|
vc
|
VarChar(|)
|
|
nn
|
not
null
|
|
re
|
references
|(X)
|
|
u
|
unique
|
|
p
|
create
procedure |
as
begin
end
|
|
tr
|
create
trigger | on X for
as
begin
end
|
|
dp
|
drop
procedure |;
|
|
dt
|
drop
trigger |;
|
|
