/SQL/Query to generate query to drop primary keys or foreign key in ms sql server

Query to generate query to drop primary keys or foreign key in ms sql server

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += N'
ALTER TABLE ' + QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id))
    + '.' + QUOTENAME(OBJECT_NAME(parent_object_id)) + 
    ' DROP CONSTRAINT ' + QUOTENAME(name) + ';'
FROM sys.foreign_keys WHERE QUOTENAME(OBJECT_NAME(parent_object_id)) LIKE '%[tblAccount]%'

PRINT @sql;

Similar codes

0 vote262 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote292 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote267 views4 answers
Stored procedure sql
SQL
0 vote246 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote272 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote253 views1 answer
Oracle merge insert if not exists
SQL
0 vote268 views1 answer
Store case result sql
SQL
0 vote253 views2 answers
Select index table oracle
SQL
2 votes267 views1 answer
Oracle list duplicates
SQL
6 votes246 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL