Database

ALTER PROC [dbo].[DATABASE_MAINTANANCE_PLAN]
AS 
BEGIN
DECLARE @command nvarchar(max);
DECLARE @FillFactor int = 85;

    SET @command = N'ALTER INDEX ALL ON [?] REBUILD WITH (FILLFACTOR = ' + Convert(nvarchar(3), @FillFactor) + N')';
    EXEC sp_MSforeachtable @command; 
END

ALTER   TABLE table1 ADD
UNIQUE(column)

ALTER TABLE table2  ADD  

FOREIGN KEY (column) REFERENCES table1(column); 

srikrishnathanthri wrote:

Is it possible to set ''ON DELETE CASCADE" without adding primary key in the parent table ?

srikrishnathanthri wrote:

But I want to add "ON DELETE CASCADE" only for Place and State.

ALTER TABLE [dbo].[Product2]  ADD CONSTRAINT 
[FK_ProductDetails_Products] FOREIGN KEY([name],[place],[state])
REFERENCES [dbo].[Product1] ([name],[Place],[state])
ON UPDATE CASCADE
ON DELETE CASCADE

ALTER TABLE dbo.Product1
ADD CONSTRAINT UX_Product1_Name_Place_State
UNIQUE NONCLUSTERED (name, Place, state)

Introducing FOREIGN KEY constraint 'FK_ProductDetails_Products' on table 'Product2' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

Error message 1785 occurs when you create a FOREIGN KEY constraint that may cause multiple cascade paths[^]:

[A] table cannot appear more than one time in a list of all the cascading referential actions that are started by either a DELETE or an UPDATE statement.

DECLARE @var AS NVARCHAR -- or whatever you have
SELECT @var = field1 FROM table1 WHERE ... -- it should be a condition to return a single row

Vienna Cheesecake
Caramel Crunch
Wedding Package
Graduation Sprinkles Cake
Red Velvet Cupcake
Original Cookies

DECLARE @var NVARCHAR(MAX)
SET @var = ''
SELECT @var = @var + '[LINE-BREAK]' + field1 + field2 + field3 FROM table1
SELECT @var

kmllev wrote:

What would you advise?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]