Using keyboard templates
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 |; |
| 
