Use Master; Drop Database Demo; Create Database Demo; Use Demo; Go /*------------------------------------------- Schema and Tables -------------------------------------------*/ CREATE SCHEMA [Sales] Go --Create a table in using the schema Create Table [Sales].[Order] ( OrderID int not null, OrderDate datetime not null default getdate(), ProductID int not null, Quantity int null ); -- Run Select select * from [Order]; -- Must Use The Schema select * from [Sales].[Order]; -- Insert a record to the table: default value will be set Insert [Sales].[Order] (OrderID, ProductID) values (3, 900) Select * from [Sales].[Order]; -- Insert another record Insert Sales.[Order] values (1, '2007/08/20 11:30', 566, 12) -- Run Select To Check The Data select * from Sales.[Order] -- This will generate data type errors on date (no 13 month) Insert Sales.[Order] values(4, '2007/13/12', 22, 10) -- Add a new column to the table (at the end) Alter table Sales.[Order] add NewCol char(10) null; -- Check For New Column Select * from [Sales].[Order]; Insert Sales.[Order] values(4, GETDATE(), 22, 10, 'newtext') Select * from [Sales].[Order]; -- Alter Column Datatype alter table Sales.[Order] alter column NewCol char(100); -- Now Try To Alter The Column Datatype to char(1): Alter table Sales.[Order] alter column NewCol char(1); -- Error - Data Would Be Truncated -- Drop column Alter table Sales.[Order] drop column NewCol; --drop table Drop table Sales.[Order]