■management studio でCREATE文抽出
CREATE TABLE [dbo].[V7ﾃﾞｰﾀ](
[部署ｺｰﾄﾞ] [smallint] NULL,
[伝票種別] [int] NULL,
[処理区分] [smallint] NULL,
[ﾕｰｻﾞｰｺｰﾄﾞ] [int] NOT NULL,
[処理日] [smalldatetime] NOT NULL,
[ﾃﾞｰﾀNO] [int] NOT NULL,
[商品ｺｰﾄﾞ] [int] NULL,
[商品名] [nvarchar](62) NULL,
[摘要] [text] NULL,
[数量] [money] NULL,
[単価] [float] NULL,
[金額] [money] NULL,
[入金] [money] NULL,
[tax] [money] NULL,
[営業担当] [smallint] NULL,
[納品担当] [smallint] NULL,
[単位] [nvarchar](4) NULL,
[商圏ｺｰﾄﾞ] [smallint] NULL,
[物件ｺｰﾄﾞ] [int] NULL,
[更新] [bit] NULL,
[伝票日付] [datetime] NULL,
[残高] [money] NULL,
[今回指針] [smallmoney] NULL,
[前回指針] [money] NULL,
[前検針日] [smalldatetime] NULL,
CONSTRAINT [PK__V7ﾃﾞｰﾀ1__78DED853] PRIMARY KEY CLUSTERED
(
[ﾕｰｻﾞｰｺｰﾄﾞ] ASC,
[処理日] ASC,
[ﾃﾞｰﾀNO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
■postgresのalterでプライマリー鍵設定する場合
特殊文字は “で囲まないと正しく列名やテーブル名などはpostgres側には入らない
ALTER TABLE “V7ﾃﾞｰﾀ” ADD CONSTRAINT “V7ﾃﾞｰﾀ_pkey” PRIMARY KEY(“ﾕｰｻﾞｰｺｰﾄﾞ”, “処理日”, “ﾃﾞｰﾀNO”);
機械的にやれないことも以下でないか、、、、
■該当テーブルのテーブル名を抽出
■該当テーブルのprimary鍵を抽出
これだけあれば作れるけどもはやマンパワーで分担した方がはやい？？？
