check_database_columns

set nocount on

create table ##check_database_columns (
    table_qualifier sysname,
    table_owner sysname,
    table_name sysname,
    column_name sysname,
    data_type smallint,
    type_name sysname,
    [precision] int,
    length int,
    scale smallint,
    radix smallint,
    nullable smallint,
    remarks varchar(254),
    column_def nvarchar(4000),
    sql_data_type smallint,
    sql_datetime_sub smallint,
    char_octet_length int,
    ordinal_position int,
    is_nullable varchar(254),
    ss_data_type tinyint
)

exec sp_MSforeachtable @command1 = '
    declare @@tmp nvarchar(500)
    set @@tmp = object_name(object_id(''?''))
    insert into ##check_database_columns exec sp_columns @@tmp
'

select * from ##check_database_columns

drop table ##check_database_columns