Posts

Showing posts from September, 2021

rename column name in sql server

  EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName' , 'COLUMN'

Create Table with primary key In SQL

creating a table with a primary key to store the pdf path and some of the details.  Here is a query to create a table in SQL and oracle CREATE TABLE TBL_ITG_PDF_DOCUMENT_LIBRARY   (    ID int NOT NULL PRIMARY KEY ,    PolicyName varchar ( 500 ) ,     Description varchar ( max ),      DocumentPath nvarchar ( max ),      UploadedBy varchar ( 100 ),    UploadedDate date ,     );