A collection of SQL snippets for Sublime Text 2.
Copy into your Sublime Text 2 'User' folder or in a subfolder (like ../sublime-text-2/Packages/User/snippets/SQL/
).
You can also copy the snippets directly in the SQL folder under ../sublime-text-2/Packages/SQL/snippets/
.
Tab Trigger:
- ct => create table
- aatc => add another table column
- cpk => constraint primary key
- cfk => constraint foreign key
- cv => create view
- atpk => alter table primary key
- atfk => alter table foreign key
- ij => inner join
- gr => grant rights
- iit => insert into table
- ut => update table
- dft => delete from table
- sft => select from table
Thank you.