TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
baskaran chellasamy
NA
114
151k
How to view the store procedure table schema and how to modify store procedure table parameters
Jul 16 2012 3:22 PM
Hello friends
Below is my table
create
procedure
studenttable
as
create
table
studenttable
(
Stud_regno
int
,
Stud_id
int
primary
key
,
Stud_name
varchar
(
50
),
Dob
date
,
gender
varchar
(
20
),
father_name
varchar
(
50
),
mother_name
varchar
(
50
),
father_occupation
varchar
(
40
),
mother_occupation
varchar
(
40
),
contact_no
bigint
,
email_id
varchar
(
200
),
street
varchar
(
250
),
city
varchar
(
50
),
state
varchar
(
100
),
country
varchar
(
50
),
zipcode
bigint
);
From this table i want to view the table structure and how to modify any of the parametes
please help me
thank you all
Reply
Answers (
2
)
what is cursor ? where we use cursor ?
Can we use Truncate Command on a Table which is Referenced by FOREIGN KEY