/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 vote239 views1 answer
How to make full text search dynamic in mysql
SQL
14 votes208 views3 answers
SQL trim
SQL
0 vote225 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote173 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
4 votes169 views3 answers
Order by value mysql
SQL
0 vote198 views1 answer
Query builder doctrien return sql
SQL
0 vote193 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote173 views1 answer
Mysql remove tabs from string
SQL
-1 vote274 views1 answer
Brisanje dupliranih konatakata
SQL
1 vote200 views1 answer
Postgres count string length
SQL