|
4> --Create a schema
5> CREATE SCHEMA Sales
6> GO
1>
2>
3> --Create a table in the schema
4> CREATE TABLE Sales.SalesData
5> (
6> SaleNumber INT,
7> SaleDate DATETIME
8> )
9> GO
1>
2>
3> --
4> SELECT *
5> FROM Sales.SalesData
6> GO
SaleNumber SaleDate
----------- -----------------------
(0 rows affected)
1>
2>
3> drop table Sales.SalesData;
4> GO
1>
2> drop SCHEMA Sales;
3> GO
|