/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

14 votes136 views2 answers
Oracle limit rows
SQL
0 vote124 views1 answer
Pgsql is not permitted to log in
SQL
23 votes137 views1 answer
How remove column in mysql
SQL
0 vote156 views1 answer
Mysql last friday of current month
SQL
0 vote150 views1 answer
Nuget sqllite-net-pcl
SQL
2 votes176 views2 answers
Postgres drop column if exists
SQL
0 vote81 views1 answer
Update row in sqlite python
SQL
0 vote126 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote119 views1 answer
Check if a word appears at the end sql query
SQL
0 vote175 views1 answer
Oracle plsql sleep
SQL