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

Question

Hi,

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?

Answer 1

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.

Answer 2

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

Answer 3

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.

Answer 4

Sql Server:

To see if the change was applied, use

SELECT * FROM sys.syscolumns WHERE id = OBJECT_ID('TABLE_NAME')

Where the length column should tell you the length of the varchar column in question.