/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 vote157 views1 answer
Alter table add check constraint oracle
SQL
0 vote176 views1 answer
Get create sql of hibernqte entity
SQL
1 vote151 views2 answers
Oracle replace
SQL
2 votes148 views2 answers
Enable foreign key checks postgres
SQL
3 votes231 views3 answers
Mysql get table size
SQL
0 vote154 views1 answer
Sql query to force the database to be drop
SQL
15 votes154 views4 answers
Create table if not exists sql
SQL
6 votes168 views3 answers
What is where in sql
SQL
0 vote186 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote165 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL