質問編集履歴
1
CREATE文を記載します
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -22,6 +22,31 @@
|
|
|
22
22
|
DB：SQLServer2019
|
|
23
23
|
キー項目：列1 char(2), 列2 char(2)
|
|
24
24
|
|
|
25
|
+
- リスト実際のDB名・テーブル名・項目名を置換したCREATE文を記載します。
|
|
26
|
+
|
|
27
|
+
USE [サンプルDB]
|
|
28
|
+
GO
|
|
29
|
+
|
|
30
|
+
/****** Object: Table [dbo].[TABLE1] Script Date: 2022/10/14 9:36:33 ******/
|
|
31
|
+
SET ANSI_NULLS ON
|
|
32
|
+
GO
|
|
33
|
+
|
|
34
|
+
SET QUOTED_IDENTIFIER ON
|
|
35
|
+
GO
|
|
36
|
+
|
|
37
|
+
CREATE TABLE [dbo].[TABLE1](
|
|
38
|
+
[列1] [char](2) NOT NULL,
|
|
39
|
+
[列2] [char](2) NOT NULL,
|
|
40
|
+
[列3] [char](3) NULL,
|
|
41
|
+
CONSTRAINT [PK_TABLE1] PRIMARY KEY CLUSTERED
|
|
42
|
+
(
|
|
43
|
+
[列1] ASC,
|
|
44
|
+
[列2] ASC
|
|
45
|
+
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
|
46
|
+
) ON [PRIMARY]
|
|
47
|
+
GO
|
|
48
|
+
|
|
49
|
+
|
|
25
50
|
### 発生している問題・エラーメッセージ
|
|
26
51
|
|
|
27
52
|
```
|