Query to search table name in SP, Trigger and Views

SELECT DISTINCT so.name,so.xtype

FROM syscomments sc

INNER JOIN sysobjects so ON sc.id=so.id

WHERE sc.TEXT LIKE '%tablename%'

Deleting All Keys or constraints from database

DECLARE

@Sql NVARCHAR(500) DECLARE @Cursor CURSOR

SET

@Cursor = CURSOR FAST_FORWARD FOR

SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'

FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1

LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME

OPEN

@Cursor FETCH NEXT FROM @Cursor INTO @Sql

WHILE

(@@FETCH_STATUS = 0)

BEGIN

Exec SP_EXECUTESQL @Sql

FETCH NEXT FROM @Cursor INTO @Sql

END

CLOSE

@Cursor DEALLOCATE @Cursor

Convert SQL table into XML format

Below is the SQL query to convert any table in XML format

SELECT * from Assessment1_GeneralFormulation for XML RAW , ROOT ('table'), ELEMENTS XSINIL

How to Find Tables With Primary Key Constraint in Database

Script to find all the primary key constraint in database:
USE DataBaseName;
GO
SELECT i.name AS IndexName,
OBJECT_NAME(ic.OBJECT_ID) AS TableName,
COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic
ON i.OBJECT_ID = ic.OBJECT_ID
AND i.index_id = ic.index_id
WHERE i.is_primary_key = 1