SQL statement operation database structure

xiaoxiao2021-03-06  72

A common problem

Increasing a VARCHAR column to the table: ALTER TABLE distributors ADD COLUMN address VARCHAR (30); the existing columns renamed: ALTER TABLE distributors RENAME COLUMN address TO city; the existing table renamed: ALTER TABLE distributors RENAME TO suppliers; increasing a to a table Foreign key constraints: Alter Table Distributors Add Constraint Distfk Foreign Key (Address) References Addresses (Address) Match Full

转载请注明原文地址:https://www.9cbs.com/read-121034.html

New Post(0)