Advertisement
josemld

script_examen3_bd_librosautor

Mar 25th, 2024
16
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.04 KB | Source Code | 0 0
  1. USE [master]
  2. GO
  3. /****** Object: Database [BD_EX03_LIBROS_AUTOR] Script Date: 25/03/2024 12:06:33 p.m. ******/
  4. CREATE DATABASE [BD_EX03_LIBROS_AUTOR]
  5. CONTAINMENT = NONE
  6. ON PRIMARY
  7. ( NAME = N'BD_EX03_LIBROS_AUTOR', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.INSTITUTO_SQL\MSSQL\DATA\BD_EX03_LIBROS_AUTOR.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
  8. LOG ON
  9. ( NAME = N'BD_EX03_LIBROS_AUTOR_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.INSTITUTO_SQL\MSSQL\DATA\BD_EX03_LIBROS_AUTOR_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
  10. GO
  11. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET COMPATIBILITY_LEVEL = 130
  12. GO
  13. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  14. begin
  15. EXEC [BD_EX03_LIBROS_AUTOR].[dbo].[sp_fulltext_database] @action = 'enable'
  16. end
  17. GO
  18. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET ANSI_NULL_DEFAULT OFF
  19. GO
  20. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET ANSI_NULLS OFF
  21. GO
  22. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET ANSI_PADDING OFF
  23. GO
  24. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET ANSI_WARNINGS OFF
  25. GO
  26. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET ARITHABORT OFF
  27. GO
  28. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET AUTO_CLOSE OFF
  29. GO
  30. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET AUTO_SHRINK OFF
  31. GO
  32. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET AUTO_UPDATE_STATISTICS ON
  33. GO
  34. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET CURSOR_CLOSE_ON_COMMIT OFF
  35. GO
  36. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET CURSOR_DEFAULT GLOBAL
  37. GO
  38. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET CONCAT_NULL_YIELDS_NULL OFF
  39. GO
  40. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET NUMERIC_ROUNDABORT OFF
  41. GO
  42. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET QUOTED_IDENTIFIER OFF
  43. GO
  44. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET RECURSIVE_TRIGGERS OFF
  45. GO
  46. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET DISABLE_BROKER
  47. GO
  48. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  49. GO
  50. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET DATE_CORRELATION_OPTIMIZATION OFF
  51. GO
  52. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET TRUSTWORTHY OFF
  53. GO
  54. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET ALLOW_SNAPSHOT_ISOLATION OFF
  55. GO
  56. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET PARAMETERIZATION SIMPLE
  57. GO
  58. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET READ_COMMITTED_SNAPSHOT OFF
  59. GO
  60. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET HONOR_BROKER_PRIORITY OFF
  61. GO
  62. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET RECOVERY SIMPLE
  63. GO
  64. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET MULTI_USER
  65. GO
  66. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET PAGE_VERIFY CHECKSUM
  67. GO
  68. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET DB_CHAINING OFF
  69. GO
  70. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
  71. GO
  72. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET TARGET_RECOVERY_TIME = 60 SECONDS
  73. GO
  74. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET DELAYED_DURABILITY = DISABLED
  75. GO
  76. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET QUERY_STORE = OFF
  77. GO
  78. USE [BD_EX03_LIBROS_AUTOR]
  79. GO
  80. ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
  81. GO
  82. ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
  83. GO
  84. ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
  85. GO
  86. ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
  87. GO
  88. USE [BD_EX03_LIBROS_AUTOR]
  89. GO
  90. /****** Object: Table [dbo].[LIBROS] Script Date: 25/03/2024 12:06:34 p.m. ******/
  91. SET ANSI_NULLS ON
  92. GO
  93. SET QUOTED_IDENTIFIER ON
  94. GO
  95. CREATE TABLE [dbo].[LIBROS](
  96. [id_libro] [int] NOT NULL,
  97. [titulo_libro] [varchar](250) NOT NULL,
  98. [autor_libro] [varchar](250) NOT NULL,
  99. [genero] [varchar](100) NOT NULL,
  100. [editorial] [varchar](100) NOT NULL,
  101. [nro_paginas] [int] NOT NULL,
  102. [isbn] [varchar](15) NOT NULL,
  103. [idioma] [varchar](60) NOT NULL,
  104. [tipo_encuadernacion] [varchar](60) NOT NULL,
  105. CONSTRAINT [PK_LIBROS] PRIMARY KEY CLUSTERED
  106. (
  107. [id_libro] ASC
  108. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  109. ) ON [PRIMARY]
  110. GO
  111. USE [master]
  112. GO
  113. ALTER DATABASE [BD_EX03_LIBROS_AUTOR] SET READ_WRITE
  114. GO
  115.  
Tags: Script sql bd
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement