/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

1 vote200 views1 answer
Mysql average of multiple columns
SQL
0 vote235 views1 answer
What is database username and password in mysqliconnect
SQL
3 votes237 views2 answers
Sqlite show table structure
SQL
0 vote212 views1 answer
Pip install mysqlclient error
SQL
0 vote223 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
19 votes212 views2 answers
Mysql add column after another
SQL
1 vote236 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote225 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote236 views1 answer
Sparql if bound query
SQL
2 votes269 views1 answer
How to check if a row is null in sql
SQL