Database Administration Fundamentals (WS18SQL1002) – Day 6

We have started to CREATE database objects.

  CREATE object_type object_name
  [AS structure]

So far we are making (CREATE),

  CREATE TABLE table_name
  (
    field1 datatype [null|not null] [unique] [primary key],
    field2 datatype [null|not null],
    ...
  )

modifying (ALTER)

  ALTER TABLE table_name
  ADD|DROP|ALTER COLUMN field_name datatype

and destroying (DROP) tables.

  DROP TABLE table_name

Download the class notes for day 6.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.