Selecting an entire row or column without knowing the name

[Guest_imported]

How can i select entire rows and coloumns in MS SQL server?? i need a statement that will allow me to do this because i am using vc++ and transfering the database tables to a listbox....but I wont know what the name of each column or table is...

 

[MikeTom]

try this
select SO.Id,
TableName = SO.Name,
ColumnName = SC.name

from Sysobjects SO
Inner join Syscolumns SC on SO.id = SC.id
where SO.TYpe = 'U'

notes : type 'U@ is for user type tables in the sysobjects table for that database.