SELECTsys.columns.name AS ColumnName,sys.types.name AS ColumnType,
(SELECT value
FROMsys.extended_properties
WHERE (major_id =sys.columns.object_id)AND(minor_id =sys.columns.column_id)AND(class = 1))AS ColumnDescription,sys.columns.max_length,
sys.columns.is_identity,sys.columns.is_nullable
FROMsys.columnsINNERJOIN
sys.tablesONsys.columns.object_id=sys.tables.object_idINNERJOIN
sys.typesONsys.columns.user_type_id =sys.types.user_type_id INNERJOIN
sys.schemasONsys.tables.schema_id=sys.schemas.schema_id
WHERE (sys.tables.name = @SourceName)AND(sys.schemas.name ='dbo')