mathieu_cupryk
asked on
Augument a table with several attributes
[FlagRemoved] bit
[AgentRemoved] [nvarchar](50)
[DateRemoved] [datetime]
Need to add the above to the following:
CREATE TABLE [dbo].[tbl_index_ticket_po cs](
[TicketPOCIndexID] [int] IDENTITY(1,1) NOT NULL,
[TicketID] [int] NULL,
[POCID] [int] NULL,
[DateAdded] [datetime] NULL,
[AgentAdded] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL,
[DateCreated] [datetime] NULL CONSTRAINT [DF_tbl_index_ticket_pocs_ DateCreate d] DEFAULT (getdate()),
CONSTRAINT [PK_tbl_index_ticket_pocs] PRIMARY KEY CLUSTERED
(
[TicketPOCIndexID] 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]
[AgentRemoved] [nvarchar](50)
[DateRemoved] [datetime]
Need to add the above to the following:
CREATE TABLE [dbo].[tbl_index_ticket_po
[TicketPOCIndexID] [int] IDENTITY(1,1) NOT NULL,
[TicketID] [int] NULL,
[POCID] [int] NULL,
[DateAdded] [datetime] NULL,
[AgentAdded] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_
[DateCreated] [datetime] NULL CONSTRAINT [DF_tbl_index_ticket_pocs_
CONSTRAINT [PK_tbl_index_ticket_pocs]
(
[TicketPOCIndexID] 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]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am greatful.