Create, modify, and drop databases with T-SQL DDL statementsCreating a database with T-SQL DDL statementsExample 1 – creating a database based on a model databaseExample 2 – creating a database that explicitly specifies the database data and the transaction log file's filespecs propertiesExample 3 – creating a database on multiple filegroupsModifying a database with T-SQL DDL statementsExample – adding a secondary data file to an existing databaseDropping a database with T-SQL DDL statementsCreate, modify, and drop databases with SSMS 2014Creating a database with SSMS 2014Modifying a database with SSMS 2014Dropping a database with SSMS 2014