--

--Simple CREATE TABLE Syntax (common if not using options)  
CREATE TABLE   
    [ database_name . [ schema_name ] . | schema_name . ] table_name   
    ( { <column_definition> } [ ,...n ] )  
	..[ GENERATED ALWAYS AS ROW { START | END } [ HIDDEN ] ]  
[ ; ]  

--

--

CREATE TABLE temporalTable1
(
    Id INT PRIMARY KEY
  , Val Varchar(100)
  , [ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START  
  , [ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END   
  , PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.HistorytesttemporalTable1));  
GO  

--

SELECT * FROM temporalTable1


--OUTPUT

Id          Val        ValidFrom       ValidTo      
----------- ---------- ------------ -- ------------ 
                                                    
(0 rows affected)                                   
                                                    
--

--

ALTER TABLE temporalTable1 
	ALTER COLUMN [ValidFrom] ADD HIDDEN
GO

ALTER TABLE temporalTable1 
	ALTER COLUMN [ValidTo] ADD HIDDEN
GO                              
                                                    
--OUTPUT

	Commands completed successfully.

SELECT * FROM temporalTable1


--OUTPUT

Id          Val
----------- -----------

(0 rows affected)
                                
                                                    
--

--

ALTER TABLE temporalTable1 
	ALTER COLUMN [ValidFrom] DROP HIDDEN
GO

ALTER TABLE temporalTable1 
	ALTER COLUMN [ValidTo] DROP HIDDEN
GO
                            
                                                    
--