CREATE PROC dbhelp
(
    @TableName varchar(50) =null,
    @SchemaName varchar(50) = null
)
AS
BEGIN
SELECT o.name AS ObjectName,c.name
as ColumnName,TYPE_NAME(c.user_type_id) as DataType FROM sys.objects o
inner join sys.columns c on o.object_id =c.object_id
where o.name=@TableName and o.schema_id =schema_id(@SchemaName)

END

ObjectName ColumnName DataType
DimEmployee EmployeeKey int
DimEmployee ParentEmployeeKey int
DimEmployee EmployeeNationalIDAlternateKey nvarchar
DimEmployee ParentEmployeeNationalIDAlternateKey nvarchar
DimEmployee SalesTerritoryKey int
DimEmployee FirstName nvarchar
DimEmployee LastName nvarchar
DimEmployee MiddleName nvarchar
DimEmployee NameStyle bit
DimEmployee Title nvarchar
DimEmployee HireDate date
DimEmployee BirthDate date
DimEmployee LoginID nvarchar
DimEmployee EmailAddress nvarchar
DimEmployee Phone nvarchar
DimEmployee MaritalStatus nchar
DimEmployee EmergencyContactName nvarchar
DimEmployee EmergencyContactPhone nvarchar
DimEmployee SalariedFlag bit
DimEmployee Gender nchar
DimEmployee PayFrequency tinyint
DimEmployee BaseRate money
DimEmployee VacationHours smallint
DimEmployee SickLeaveHours smallint
DimEmployee CurrentFlag bit
DimEmployee SalesPersonFlag bit
DimEmployee DepartmentName nvarchar
DimEmployee StartDate date
DimEmployee EndDate date
DimEmployee Status nvarchar
DimEmployee EmployeePhoto varbinary