i have no idea what's wrong. i have tried with many codes, still not working :/

Is it possible to flag a table as a Temporal Table as defined in MS SQL Server 2016 and later?

Temporal tables are declared with the following syntax:

CREATE TABLE Department
(
DeptID INT NOT NULL PRIMARY KEY CLUSTERED,
DeptName VARCHAR(50) NOT NULL,
ManagerID INT NULL,
ParentDeptID INT NULL,
ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL,
ValidTo DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL,
PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
)
WITH (SYSTEM_VERSIONING = ON);

The bold elements define the table as a Temporal table (Temporal tables - SQL Server | Microsoft Learn)

I can get the WITH clause using the 'WITH options' under additional properties for the table, and I can create 'ValidFrom' and 'ValidTo' columns of type datetime2, but I can't see a way to set the properties of those columns to correctly apply GENERATED ALWAYS AS ROW START and GENERATED ALWAYS AS ROW END, or to apply the PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo) property.  I can probably use a text macro in notepad++ on the generated SQL to add this but it would be nice if it was supported in Vertabelo?

Hi Team,
do you have in your product development plans integration with Databricks (datatypes, table properties, informative constraints)

TIMESTAMP_NTZ is not in standard data type nor
binary with precision ...
impossible to load SQL script from snowflake :(

Unlock new career opportunities by mastering ServiceNow ITOM Training ! Our comprehensive training equips you with the knowledge and skills needed to excel in modern IT operations, enabling you to deliver optimized, automated IT services.

Key Learning Areas

• Service Discovery: Learn to automatically map and monitor your IT infrastructure.
• Event Management: Gain expertise in handling real-time event data for proactive IT operations.
• Orchestration: Master workflow automation to improve efficiency and reduce manual tasks.
• Cloud Management: Understand how to manage hybrid environments seamlessly.

Why Choose Us?

Our expert-led training combines theoretical knowledge with hands-on experience, ensuring you're ready to tackle real-world challenges. Whether you're an IT professional looking to upskill or an organization aiming to improve service delivery, our ServiceNow ITOM training provides the tools for success. Start today and transform your career!

4o mini

Hello!
Could you please add the domain kerschensteinerschule.de (Public Vocational School Center in stuttgart, Germany) to the white list of Educational Institutions (public high schoo) so that my database students can create an account?
Thank you very much.

Hello my account ends in @ustabuca.edu.co from santo tomas university bucaramanga colombia, meaning that my email address is definitely an academic email address, but it won't let me create an academic account

Hello my account ends in @uniriotec.br from the Brazilian Federal University Unirio (unirio.br) and "tec" because it's the technology school, meaning that my email address is definitely an academic email address, but it won't let me create an academic account. Can you help me with this? Thanks. 

I would like to request that the Federal University of Mato Grosso (UFMT - Brazil) be added to the whitelist so that my Computer Engineering students can use your software in their Database Modeling classes.

Website: https://www.ufmt.br/

I am looking to understand the main functionalities and benefits of SAP FICO (Financial Accounting and Controlling) in streamlining financial processes, such as accounts payable, accounts receivable, asset accounting, and cost center accounting. How does it contribute to more effective financial reporting and internal cost control within an organization?