Symbian Developer Library

SYMBIAN OS V6.1 EDITION FOR C++

[Index] [Glossary] [Previous] [Next]



SQL schema update statements (DDL)


Create table statement

create-table-statement : CREATE TABLE table-name (column-definition-comma-list)

[Top]


Drop table statement

drop-table-statement : DROP TABLE table-name

[Top]


Alter table statement

alter-table-statement : ALTER TABLE table-name { ADD add-column-set [ DROP drop-column-set ] | DROP drop-column-set }

[Top]


Create index statement

create-index-statement : CREATE [ UNIQUE ] INDEX index-name ON table-name ( sort-specification-comma-list )

[Top]


Drop index statement

drop-index-statement : DROP INDEX index-name FROM table-name