Knowledge Share

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

Share | 
 

 To View All Tables in the DB

View previous topic View next topic Go down 
AuthorMessage
Admin
Admin


Posts : 141
Points : 407
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
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
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» Security Alert with yes, no, view certificate button
» First Impressions: Wii U Panorama View
» Change The Control Panel to Classic View in Windows 7
» Change Windows 7 Control Panel to Classic View
» Reset Windows Explorer Folder View Settings in Windows 7

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