hi
How to Restrict Delete records Particular Table
For Ex : My table structure below here
GO
/****** Object: Table [dbo].[Tb_Test123] Script Date: 08/09/2011 12:43:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tb_Test123](
[id] [int] IDENTITY(1,1) NOT NULL,
[Enames] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_Tb_Test123] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
i have create one table table name Tb_Test123 but no relationship but i need
this table only i need donot execute delete query
any one pass delete from Tb_Test123 did not execute in my db this i need
how do achieve this.
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com