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

  EXEC sp_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