SQL Server Management Studio
| sys.views | |
| sys.columns | , |
| sys.sql_expression_dependencies | : ; ; , . |
| sys.sql_modules | SELECT |
| sys.dm_sql_referenced_entities | , : , ; ; , , ; ; XML-; . |
, 1 024 .
CREATE VIEW:
CREATE VIEW [ schema_name. ] view_name [ (column [,...n ]) ]
[ WITH [ ENCRYPTION ] [ SCHEMABINDING ] ]
AS select_statement
[ WITH CHECK OPTION ]
schema _ name
, .
view_name
. , . .
column
, . , , , ( , ) , , . SELECT.
column , , SELECT.
AS
, .
select_statement
SELECT, . . SELECT , , .
select_statement SELECT, UNION UNION ALL.
CHECK OPTION
, select_statement. , WITH CHECK OPTION , , .. , . , , , CHECK OPTION.
|
|
|
ENCRYPTION
CREATE VIEW . .
SCHEMABINDING
. SCHEMABINDING , , . , . SCHEMABINDING select_statement (schema. object) , , . .
, , Database Engine . , , . SQL Server , , . SCHEMABINDING , , , SCHEMABINDING, , , . Database Engine . , ALTER TABLE , , , , .
SCHEMABINDING , .
:
EmployeeHireDate, , .
CREATE VIEW EmployeeHireDate
AS
SELECT p.FirstName, p.LastName, e.HireDate
FROM HumanResources.Employee AS e JOIN Person.Person AS p
ON e.BusinessEntityID = p.BusinessEntityID;
ALTER VIEW , CREATE VIEW.
ALTER VIEW [ schema_name. ] view_name [ (column [,...n ]) ]
[ WITH [ ENCRYPTION ] [ SCHEMABINDING ] ]
AS select_statement
[ WITH CHECK OPTION ]
WITH ENCRYPTION CHECK OPTION, , ALTER VIEW.
:
EmployeeHireDate, , , , , 2009 .
|
|
|
ALTER VIEW HumanResources.EmployeeHireDate
AS
SELECT p.FirstName, p.LastName, e.HireDate
FROM HumanResources.Employee AS e JOIN Person.Person AS p
ON e.BusinessEntityID = p.BusinessEntityID
WHERE HireDate < CONVERT(DATETIME,'20090101',101);
GO
DROP VIEW:
DROP VIEW [ schema_name. ] view_name [...,n ]
schema_name
, .
view_name
.
:
EmployeeHireDate HumanResources.
DROP VIEW HumanResources.EmployeeHireDate;
