in table design view(right click table and choose design), right click on a column, and select ‘relationship‘, then create your foreign keys,
sql, stop changes that require recreating table: select tools ->options-> designer, then remove checked from prevent allowing changes that will recreate table.
sql server create foreign key
标签：