Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql change column type


        
            
        
     ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;
Comment

update column data type postgres

ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;
 
Comment

change data type postgresql

ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;
Code language: CSS (css)
Comment

PREVIOUS NEXT
Code Example
Sql :: show constraints mysql 
Sql :: how to get duplicate records with multiple field in sql 
Sql :: how to check if a row is null in sql 
Sql :: mysql limit rows 
Sql :: change role postgres 
Sql :: how to print mysql query of codeigniter query builder 
Sql :: create pl/sql stored procedure 
Sql :: pl/sql loop example 
Sql :: c# sql select 
Sql :: sql in array query 
Sql :: add primary key with auto increment sql server 
Sql :: snowflake datetrunc month 
Sql :: mysql subdate 
Sql :: oracle create table auto generated primary key 
Sql :: how to use rank function in sql 
Sql :: Get the Db column names from a SqlDataReader 
Sql :: oracle list columns in schema 
Sql :: Check user permissions on postgres database 
Sql :: sql server output parameter 
Sql :: mysql replace remove html tag 
Sql :: Postgresql get diff between two dates in Months 
Sql :: java sql timestamp now 
Sql :: default constraint in ms sql 
Sql :: postgres : ERROR: division by zero 
Sql :: mysql update with join 
Sql :: sql left characters 
Sql :: drop column from local database postgres pgadmin 
Sql :: How to add a Try/Catch to SQL Stored Procedure 
Sql :: update join sql 
Sql :: sql substring 
ADD CONTENT
Topic
Content
Source link
Name
9+5 =