SQL
CREATE TABLE Book (
ISBN VARCHAR(40) PRIMARY KEY,
Title VARCHAR(100)
)
+ Add column
Columns
| Column |
Data type |
Allow null |
Primary key |
Actions |
ISBN |
VARCHAR(40) |
✓ |
✓ |
Rename
|
Drop
|
Title |
VARCHAR(100) |
✓ |
|
Rename
|
Drop
|
+ Add index
Indexes
| Name |
Columns |
Unique |
SQL |
Drop? |
| sqlite_autoindex_Book_1 |
ISBN
|
✓ |
SQL
-- no sql found --
|
Drop
|