Home > database >  Sybase database query table of all fields
Sybase database query table of all fields

Time:09-22

New to sybase will not quite, can you tell me how to query a table sybase all of the fields?

CodePudding user response:

Select * from table name

CodePudding user response:

Beginner can learn a lesson look at w3school, http://www.w3school.com.cn/is simple

CodePudding user response:

- enter the database
Use & lt; Db_name & gt;
Go

Sp_help & lt; Table_name & gt;
Go

CodePudding user response:

Another method:

- enter the database
Use & lt; Db_name & gt;
Go

Select * from syscolumns where id=object_id (' & lt; Table_name & gt; ')
Go

Ps: is there any company with sybase now, I'm an expert, can provide paid support!!!!!
I can add the public number eBookhub.
  • Related