.
SQL Server Management Studio. Postavki, Security (), Schemas (). Create Schema ( ). , dbo.
.
Tables Create Table. .
. a Data Type - char ( ) .
Allow Nulls . , .
.
. Set primary key.
. Table Properties () . E , View | Properties Window ( | ). Schema , . .
, Save, .
Tables. .
, , Open Table ( 200 ). .
Project().
.
, .
SQL Server Management Studio Views () Postavki.
Create View ADD Table PostDet.tblS . .
PostDet.tblS, . S SNAME. Column.
, , PostDet.
. vw_tblS.
.
SQL Server Management Studio ( Programmability() -> Stored Procedures ( ) -> Create Stored Procedure.
|
|
.
Diagrams Postavki Install Diagrams Support ( ) Yes. New Database Diagram, , Add.
, , .
.
, .
1. PostDet.tblS.
SQL Server Management Studio c, Postavk i :
ALTER TABLEPostDet.tblS DROP COLUMN CITY;
, , . .
2. PostDet.tblS.
ALTER TABLE PostDet.tblS ADD CITY CHAR(8);