/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 vote232 views1 answer
Oracle rolling back
SQL
0 vote243 views1 answer
Oracle array
SQL
4 votes301 views2 answers
Sql display today's date
SQL
0 vote260 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote253 views1 answer
Php mysqli install
SQL
1 vote207 views1 answer
Mysql get last insert id
SQL
0 vote227 views1 answer
Mysql function variable
SQL
3 votes274 views2 answers
Truncate table
SQL
1 vote247 views1 answer
Sql server loop over query
SQL
10 votes232 views2 answers
Sql rtrim
SQL