Altering Tables

After you create a table, you might want to change its structure by adding columns, adding record keys, or changing constraints. To change a table, you alter its definition.

    To alter a table definition

• In SQL Enterprise Manager's Server Manager window, double-click the appropriate table, and then make the appropriate changes.

  (For details, search for "table" in SQL Enterprise Manager Help.)

Or

• Use the ALTER TABLE statement.

  For example:

  ALTER TABLE publishers
  ADD
  COUNTRY varchar(30) NULL
  DEFAULT('USA')

  adds the country column to the pubs database. (Note that this column already exists in the SQL Server 6.0 pubs database.)

  (For details, see the ALTER TABLE statement in the Microsoft SQL Server Transact-SQL Reference.)