Bd_supermercado
Enviado por Deivid Bryan Cruz León • 8 de Junio de 2020 • Tareas • 325 Palabras (2 Páginas) • 99 Visitas
CREATE DATABASE BD_SUPERMERCADO
ON
(
NAME=MERCADO_PRI,
FILENAME='D:\MERCADO\DF\HOTEL.MDF',
SIZE=20MB,
MAXSIZE=100MB,
FILEGROWTH=15%
)
LOG ON
(
NAME=MERCADO_LOG,
FILENAME='D:\MERCADO\LF\HOTEL.LDF',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=5MB
)
GO
ALTER DATABASE BD_SUPERMERCADO
ADD FILEGROUP FGSUPER01
GO
ALTER DATABASE BD_SUPERMERCADO
ADD FILEGROUP FGSUPER02
GO
ALTER DATABASE BD_SUPERMERCADO
ADD FILEGROUP FGSUPER03
GO
ALTER DATABASE BD_SUPERMERCADO
ADD FILE
(
NAME=MERCADO_SEC1,
FILENAME='D:\MERCADO\SF\MERCADO_SEC1'
)TO FILEGROUP FGSUPER01
go
ALTER DATABASE BD_SUPERMERCADO
ADD FILE
(
NAME =MERCADO_SEC2,
FILENAME='D:\MERCADO\SF\MERCADO_SEC2'
)TO FILEGROUP FGSUPER02
go
ALTER DATABASE BD_SUPERMERCADO
ADD FILE
(
NAME =MERCADO_SEC3,
FILENAME='D:\MERCADO\SF\MERCADO_SEC3'
)TO FILEGROUP FGSUPER03
go
create Schema Ventas
GO
create Schema Gerencia
GO
create type TEXTO
...