/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 vote158 views1 answer
Returning with sqlalchemy
SQL
0 vote161 views1 answer
Implicit inner join table alias with id values
SQL
0 vote221 views2 answers
Search stored procedures by name
SQL
0 vote155 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
1 vote148 views1 answer
Sql get all columns from one table but one from another inner join
SQL
6 votes247 views1 answer
Sql insert values into table
SQL
1 vote151 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
10 votes158 views2 answers
Sql rtrim
SQL
0 vote157 views1 answer
Change schema of all tables postgres
SQL
6 votes147 views2 answers
How to copy data in sql
SQL