Stream, StreamReader, StreamWriter

Question

Hi, I have to make a client-server app. and for stream I have to use the object Stream, StreamReader and StreamWriter. I am not familiar with those object. It would be good if someone could explain to me what StreamReader and StreamWriter can do. I am pretty sure that the object Stream will be used to send and received data. Is StreamWriter will enable me to write in the stream and send the data ? and StreamReader to read from the stream? Cuz those object can take a stream in parameter.

Answer 1

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') if it exist then it will display the result,,,with table name ,,,tpe and everything

Answer 2

Select your database and open new query window and

EXEC sp_tables @table_type = "'table'"

Answer 3

hi,

there are two tables sys.tables and sys.objects, in which data base maintain table information
please try.

select * from sys.tables where name = 'Table1'

select * from sys.objects where type = 'U' and type_desc = 'USER_TABLE'

hope this will help you.