Kan64
asked on
Column metadata
I want to extract column metadata such as column data type, MaxSize,IsPrimaryKey, IsForeignKey.
I tried this but getting null instead of true/false
use Northwind
select COLUMNPROPERTY(OBJECT_ID(' Customers' ), 'CustomerID', 'IsPrimaryKey')
thanks
I tried this but getting null instead of true/false
use Northwind
select COLUMNPROPERTY(OBJECT_ID('
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.