I figured out what the problem was.

I was declaring the variable having the datatype NVARCHAR, where they should be declared as VARCHAR 🙁

Thanks

Hi, I was trying to use xp_delete_file in one of my stored procedure. I was tryign to pass all the parameters like folderPath, FileType and Date to delete the files...

You can simply try using:

SELECT [name] from sys.default_constraints

WHERE parent_object_id = OBJECT_ID(N'[dbo].tbYourTableName')

...