We aren't allowed to create packages and procedures in the database.
So I have to use JDBC to do what a script which contains DML (Alter
Table Disable Constraint) and an Anonymous PL/SQL block (not
server-side compiled).
Can this be done in JDBC/Java and how? Thanks much.
Re: automate tool to change column type? ...schema ahead of time. ... is the change such that you can do it with ALTER TABLE? ... but save and carefully review the script.... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (microsoft.public.sqlserver.tools)
Re: sql nvarchar(50) ...alter column CategoryName nvarchar ...Script out your table to make sure that the column size is actually ... >I have a table with a column CategoryName as nvarchar. ... Are nvarchars stuck!!... (microsoft.public.sqlserver.programming)
Re: Rewritten play ... playwright is the soul of the theatre and the writer's script is at the heart of what we do. ... To alter it to fit one's own concept is to be a traitor to the theatre. ...Dave: So, you'd be willing to give up evil for Lisa? ...Johnny Johnson: Teaching English as a second language. ... (rec.arts.theatre.plays)
Re: ALTER IDENTITY setting... ...Enterprise Manager would do. ... I also would suggest you use EM and save the script....Pro SQL Server 2000 Database Design - ... > I just need to alter column with Identity. ... (microsoft.public.sqlserver.programming)
Re: Row size and DBCC SHOWCONTIG ...Andrew J. Kelly SQL MVP ... > Since I had to drop all dependent objects before issuing the ALTER COLUMN,... >> Amy,... >> Sorry but I didn't even see the script the first time. ... (microsoft.public.sqlserver.programming)
