select cols.COLUMN_NAME, case  when cols.DOMAIN_NAME is not null then cols.DOMAIN_NAME COLLATE Latin1_General_BIN else cols.DATA_TYPE end as datatype, cols.DATA_TYPE as basetype, cols.CHARACTER_MAXIMUM_LENGTH, cols.NUMERIC_PRECISION, cols.NUMERIC_SCALE from  INFORMATION_SCHEMA.COLUMNS cols where cols.TABLE_CATALOG = N'webaccess' and cols.TABLE_SCHEMA = N'dbo' and cols.TABLE_NAME = N'prj_planing' order by cols.ORDINAL_POSITION 
go
 SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(NULL,N'user',N'dbo',N'table',N'prj_planing',NULL,NULL) 
go
 SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(NULL,N'user',N'dbo',N'table',N'prj_planing',N'column',NULL) ORDER BY PATINDEX(N'MS_DisplayControl', name) DESC 
go
SET ROWCOUNT  10000  
go
 SELECT * FROM  "dbo" . "prj_planing"  
go
select object_name(sofk.id), user_name(sofk.uid), 'FK' from sysreferences srfk, sysobjects sofk, sysobjects sotblfk where srfk.constid = sofk.id and srfk.fkeyid = sotblfk.id and user_name(sotblfk.uid) = N'dbo' and object_name(sotblfk.id) = N'prj_planing_time'union select object_name(sofk.id), user_name(sofk.uid), 'RK' from sysreferences srfk, sysobjects sofk, sysobjects sotblrk where srfk.constid = sofk.id and srfk.rkeyid = sotblrk.id and user_name(sotblrk.uid) = N'dbo' and object_name(sotblrk.id) = N'prj_planing_time' 
go
select object_name(sofk.id), user_name(sofk.uid), 'FK' from sysreferences srfk, sysobjects sofk, sysobjects sotblfk where srfk.constid = sofk.id and srfk.fkeyid = sotblfk.id and user_name(sotblfk.uid) = N'dbo' and object_name(sotblfk.id) = N'prj_planing'union select object_name(sofk.id), user_name(sofk.uid), 'RK' from sysreferences srfk, sysobjects sofk, sysobjects sotblrk where srfk.constid = sofk.id and srfk.rkeyid = sotblrk.id and user_name(sotblrk.uid) = N'dbo' and object_name(sotblrk.id) = N'prj_planing' 
go