/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 vote142 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote137 views1 answer
Mysql find non alphanumeric characters
SQL
1 vote156 views1 answer
Mysql strict_trans_tables
SQL
0 vote184 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote141 views1 answer
Postgresql substring last
SQL
8 votes155 views1 answer
Show mysql user table
SQL
16 votes135 views1 answer
Sqlserver add column to table
SQL
1 vote135 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote140 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote124 views1 answer
Count the table indatabase
SQL