/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

32 votes108 views6 answers
Insert select
SQL
4 votes134 views2 answers
Dbms output
SQL
3 votes95 views1 answer
Sql timestamp to date
SQL
0 vote145 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
5 votes121 views1 answer
Purge undo tablespace usage
SQL
3 votes106 views4 answers
Stop MySQL
SQL
0 vote124 views1 answer
Postgresql inline table
SQL
0 vote112 views1 answer
How to add unique key constraint in mysql
SQL
2 votes113 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote120 views1 answer
Compression of dabatase mysqldumo
SQL