Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Reply
How to view the store procedure table schema and how to modify store procedure table parameters
baskaran chellasamy
12 years ago
2.3k
Reply
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
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
what is cursor ? where we use cursor ?
Can we use Truncate Command on a Table which is Referenced by FOREIGN KEY