, . . SQL Server. SQL Server , :
<Server>. <Database>. <Schema>.<Object
Postavki PostDet.
SQL Server Management Studio :
-- Postavki.
USE Postavki;
GO
-- PostDet dbo.
CREATE SCHEMA PostDet
AUTHORIZATION dbo;
--dbo , sysadmin .
PostDet , .
Fred SQL Server.
Postavki : tblS, tblP tblSP, CREATE TABLE. SQL Server Management Studio :
-- Postavki.
USE Postavki;
GO
-- tblS, tblP tblSP PostDet
CREATE TABLE PostDet. tblS
(S CHAR (10) NOT NULL,
SNAME CHAR (10) NOT NULL,
STATUS INT,
CITY CHAR (10) NOT NULL,
PRIMARY KEY (S));
GO
CREATE TABLE.tblP
(P CHAR (10) NOT NULL,
PNAME CHAR (10) NOT NULL,
COLOR CHAR (10) NOT NULL,
WGT INT,
CHECK (WGT > 0 AND WGT < 100),
CITY CHAR (10) NOT NULL,
PRIMARY KEY (P));
GO
CREATE TABLE PostDet. tblSP
(S CHAR (10) NOT NULL,
P CHAR (10) NOT NULL,
QTY INT,
PRIMARY KEY (S, P),
/* */
FOREIGN KEY (S) REFERENCES PostDet.tblS
ON DELETE CASCADE /* */
ON UPDATE CASCADE,
FOREIGN KEY (P) REFERENCES PostDet.tblP
ON DELETE CASCADE
ON UPDATE CASCADE,
CHECK (QTY > 0 AND QTY < 2000));
.
CREATE TABLE The command (s) completed successfully. , CREATE TABLE .
, . .
SQL Server Management Studio Postavki Tables. , . , Refresh.
.
DROP, : DROP TABLE table_name.
.
ALTER SCHEMA
. ALTER SCHEMA :
|
|
DROP SCHEMA
DROP SCHEMA . DROP SCHEMA , . - , DROP SCHEMA .
DROP SCHEMAschema_name
.
Fred SQL Server.
Fred db_owner Postavki. :
USE Postavki
GO
EXECUTE sp_droprolemember 'db_owner', 'fs-64C67299CCAR\Fred';
Fred db_owner Postavki ( , , ), .
Fred SQL Server. SQL Server. PostDet.tblS, .
.
:
GRANT (). .
WITH GRANT ( ). . , .
DENY (). .
REVOKE () .