2
Reply

How to view the store procedure table schema and how to modify store procedure table parameters

baskaran chellasamy

baskaran chellasamy

12 years ago
2.3k
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

Answers (2)