Post reply

Script to find all filestream databases with list of Tables (contain filestream column)

  • September 19, 2013 at 5:56 am

    #279997

    Hello,

    Do you have a script to find all filestream databases with list of tables containing Filestream Column ?

    I would like a result like this :

    Name of database, Name of Table

    Thanks,

    Eric

  • September 19, 2013 at 8:32 am

    #1651541

    use this

    create table tableColumn1 (db varchar(300), tableName varchar(1000), columnName varchar(1000))

    sp_msforeachdb 'insert into tableColumn1 select "?" AS db, a.name tableName, b.name columnname from [?].sys.tables a join [?].sys.columns b on a.object_id = b.object_id order by 2,3'

    select * from tableColumn1

  • September 24, 2013 at 4:51 am

    #1652647

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply