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