/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

9 votes197 views3 answers
Date format in sql
SQL
1 vote168 views1 answer
Sql pick random row
SQL
11 votes172 views6 answers
Distinct sql
SQL
0 vote165 views1 answer
Mysql search like but first exact match
SQL
2 votes168 views1 answer
No data found oracle
SQL
3 votes175 views2 answers
How to start postgresql on windows
SQL
0 vote168 views1 answer
Sql pivot without aggregate
SQL
18 votes200 views6 answers
Laravel form validation
SQL
0 vote187 views1 answer
Query to remove duplicate rows from a table
SQL
3 votes168 views1 answer
Sql server check version
SQL