CREATE TABLE products (id MEDIUMINT NOT NULL AUTO_INCREMENT, productname VARCHAR(50), lifecyclestartdate DATE, mainstreamenddate DATE, extendedenddate DATE, notes ...

( NAME = N'Clients', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\Clients.mdf' , SIZE = 16384KB , MAXSIZE = UNLIMITED, FILEGROWTH ...