Answers for "check if table is Temporal"

SQL
0

check if table is Temporal

USE /*your db name*/
IF EXISTS (
        SELECT 1
        FROM sys.tables
        WHERE name = 'TABLE_NAME_HERE'
            AND temporal_type = 2
        )
BEGIN
     SELECT 'Yes'
 
END
ELSE
  BEGIN
     
    SELECT 'no'
 
  END

GO
Posted by: Guest on April-26-2022

Code answers related to "SQL"

Browse Popular Code Answers by Language