Knowledge Share

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

Share
 

 To View All Tables in the DB

Go down 
AuthorMessage
Admin
Admin


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

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

To View All Tables in the DB
EXEC SP_TABLES

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
http://knowledgeshare.forumotion.com
 
To View All Tables in the DB
Back to top 
Page 1 of 1

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