The Data DefinitionLanguage is used to create and manage databases and database objects, such as tables, stored procedures, user-defined functions, triggers, views, defaults, indexes, rules, and statistics. Transact-SQL provides a CREATEand a DROP statement for all these elements. Listing 2.1 shows the creation and removal of a table in the Northwind database.
USE Northwind CREATE TABLE Employeedependents ( dependentid INT IDENTITY(1,1), lastname VARCHAR(20), firstname VARCHAR(20), ) GO The command(s) completed successfully.
In addition to