In this chapter, you learned about the Transact-SQL DDL, DML, and DCL language elements. You also understood the purpose of SQL Server 2014 system databases. We then covered the purpose of database recovery models. We used the DDL language CREATE
statement to create databases, schemas, and tables. We then used the DDL language ALTER
statement to modify databases, schemas, and tables. We also used the DDL language DROP
statement to delete databases, schemas, and tables. Finally, you learned how to set permissions on SQL Server objects using the DCL language GRANT
, DENY
, and REVOKE
statements.
18.219.71.21