Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
How to view the store procedure table schema and how to modify store procedure table parameters
baskaran chellasamy
12y
2.3k
1
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