Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.31 KB | None | 0 0
  1. USE master;
  2. GO
  3.  
  4. CREATE DATABASE NewDatabase;
  5. GO
  6.  
  7. USE NewDatabase;
  8. GO
  9.  
  10. CREATE SCHEMA sales;
  11. GO
  12.  
  13. CREATE SCHEMA persons;
  14. GO
  15.  
  16. CREATE TABLE sales.Orders (OrderNum INT NULL);s
  17. GO
  18.  
  19. BACKUP DATABASE NewDatabase TO DISK='c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup\NewDatabase.bak';
  20. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement