USE Northwind
GO
SELECT object_name(o.object_id) AS TableName, c.name as IdentityColumn
FROM sys.columns c JOIN sys.objects o
ON c.object_id = o.object_id
WHERE is_identity = 1
AND o.type IN ('U')
OUTPUT:
TableName IdentityColumn
Categories CategoryID
Shippers ShipperID
Suppliers SupplierID
Orders OrderID
Products ProductID
Employees EmployeeID
No comments:
Post a Comment