/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

10 votes268 views5 answers
Mysql create user
SQL
19 votes262 views2 answers
Mysql add column after another
SQL
2 votes309 views3 answers
How to replace null values in sql
SQL
0 vote229 views1 answer
Oracle list all stored procedures
SQL
-1 vote286 views4 answers
Sql view postgresql
SQL
0 vote258 views1 answer
RowDataPacket
SQL
16 votes260 views3 answers
Delete row psql
SQL
0 vote288 views1 answer
Oracle current date minus 1 day
SQL
0 vote276 views1 answer
SQL query to verify the size of the table
SQL
2 votes282 views1 answer
Mysql create user with remote access
SQL