UPDATE fsarchive.dbo.tbl_ARC_Tables
SET sequence =
WHERE tableName =
Archive Manager
style="background:red!important;">
Archive Tables: #client.datasource#
Edit ViewNormal View
SELECT databaseName, tableName, sequence FROM fsarchive..tbl_ARC_Tables ORDER BY Sequence ASC
SELECT b.name as table_name, '1' hasPk
FROM sys.key_constraints a
INNER JOIN sys.tables b ON a.parent_object_id = b.OBJECT_ID
INNER JOIN sys.schemas c ON a.schema_id = c.schema_id
WHERE a.type = 'PK'
UNION ALL
SELECT b.name as table_name, '0' hasPk
FROM sys.tables b
INNER JOIN sys.schemas c ON b.schema_id = c.schema_id
WHERE b.type = 'U'
AND NOT EXISTS
(
SELECT a.name
FROM sys.key_constraints a
WHERE a.parent_object_id = b.OBJECT_ID
AND a.schema_id = c.schema_id
AND a.type = 'PK'
)
ORDER BY b.name ASC
SELECT TABLE_NAME, hasPk
FROM qmd_nonArchivedTables
WHERE TABLE_NAME NOT IN ( )