It return the list of table from the database you can also use it for view you have to pass view name in table type

  EXECsp_tables_ex
@table_server        ='your_linked_server_name'
,@table_catalog     ='Sample'
,@table_type        ='SignIn'

You have to give database name in table catalog and table name or view name in

table type