CODEWITHSUNDEEP
sql
Anoop
Anoop

Reputation: 2101

DataType Change from Varchar(30) to Varchar(45)

I need to test a column which changed from varchar(30) to varchar(65). I don't have a access to insert a value into that column.Is there any other way so that i can test the column?

Upvotes: 0

Views: 337

Answers (3)

Richie
Richie

Reputation: 9266

DESC TableName shows the table structure. Isn't that more than an assurance? :-D

Upvotes: 0

Rahul
Rahul

Reputation: 13056

Use "desc" in oracle or an equivalent command depending on the database to describe the table. This will list out all the table columns along with their data types.

Upvotes: 0

stimms
stimms

Reputation: 44094

Your best bet is to put together a testing database and make the change there first. Point your application at the test database and see what happens.

Upvotes: 2

Related Questions