Knowledge Share

Knowledge is NOT Power IMPLEMENTATION of knowledge is Power!!!
HomePortalGalleryCalendarFAQRegisterUsergroupsLog in

Share | 

 To View All Tables in the DB

Go down 

Posts : 142
Points : 410
Reputation : 0
Join date : 2007-12-29
Location : Chennai

PostSubject: To View All Tables in the DB   Mon Feb 08, 2010 11:16 am

To View All Tables in the DB

To Create Table
create table student ( srlno int primary key, name char(20),address as char(30))

To See the Table Structure
exec sp_columns student

To View the Tables Information

Select * from Student

Select * from Student Where name='kmr'
Back to top Go down
To View All Tables in the DB
Back to top 
Page 1 of 1
 Similar topics
» First Impressions: Wii U Panorama View
» open every link in a new tab?

Permissions in this forum:You cannot reply to topics in this forum
Knowledge Share :: .Net-
Jump to: