SQL Statement, Set Current Date, Set field to Unique

By -

1. How do I set current date and time in the field
//Set the "Date Entered" field default value to the current date and time.
ALTER TABLE "tbl_ProblemReport" ALTER COLUMN "CreateDate" SET Default CURRENT_TIMESTAMP


2. How do I create a field in a table with that must be Unique?
//Set Unique Field for "ProblemReportID" in table "tbl_ProblemReport"
//No GUI can do this
ALTER TABLE "tbl_ProblemReport" ADD CONSTRAINT MYCONSTRAINT UNIQUE ("ProblemReportID");


Comments

Post a Comment

Popular posts from this blog

Google: How to disable Auto Licensing

By -
Image
  How to disable Auto Licensing   Problem You are not able to turn off Auto Licensing in the Admin console. Environment Admin console Solution Log in to the   Admin console . Select  Billing   >   Subscriptions   >   Add or upgrade a subscription . Select  Cloud subscriptions   and enable   Cloud Identity free . Go back to the main   Subscriptions   page and select the Google Workspace edition. Click   License settings  and then turn off   Auto Licensing . Cause Auto Licensing cannot be disabled because there's only 1 subscription active in the Admin console.         Reference: https://knowledge.workspace.google.com/kb/how-to-disable-auto-licensing-000005702#problem  How to manage automatic licensing settings   Problem How to modify auto licensing in a way whenever there is an attempt to create a new user it is possible to choose which subscription that user sho...
Read more