Newsequentialid error validating default
--Disk-Based CREATE TABLE Syntax CREATE TABLE [ database_name . For more information about File Tables, see File Tables (SQL Server). ] table_name [ AS File Table ] ( [ ,...n ] [ PERIOD FOR SYSTEM_TIME ( system_start_time_column_name , system_end_time_column_name ) ] ) [ ON ] [ TEXTIMAGE_ON ] [ FILESTREAM_ON ] [ WITH ( [ FILESTREAM ] [ COLLATE collation_name ] [ SPARSE ] [ MASKED WITH ( FUNCTION = ' mask_function ') ] [ CONSTRAINT constraint_name [ DEFAULT constant_expression ] ] [ IDENTITY [ ( seed,increment ) ] [ NOT FOR REPLICATION ] [ GENERATED ALWAYS AS ROW [ HIDDEN ] ] [ NULL | NOT NULL ] [ ROWGUIDCOL ] [ ENCRYPTED WITH ( COLUMN_ENCRYPTION_KEY = key_name , ENCRYPTION_TYPE = , ALGORITHM = ' AEAD_AES_256_CBC_HMAC_SHA_256' ) ] [ [ , ...n ] ) ] [ ON ] | [ FOREIGN KEY ] REFERENCES referenced_table_name [ ( ref_column ) ] [ ON DELETE ] [ ON UPDATE ] [ NOT FOR REPLICATION ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) ] [ , ...n ] ) ] [ ON ] | FOREIGN KEY ( column [ ,...n ] ) REFERENCES referenced_table_name [ ( ref_column [ ,...n ] ) ] [ ON DELETE ] [ ON UPDATE ] [ NOT FOR REPLICATION ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) --Memory optimized CREATE TABLE Syntax CREATE TABLE [database_name . AS File Table Applies to: SQL Server 2012 through SQL Server 2017. You do not specify columns because a File Table has a fixed schema.
See: Workaround: create your table without specifying any default, and then type in this T-SQL statement in a normal query window and run it: @drasto: I ran that code on SQL Server 2008 R2 before I posted it - it works. I removed extra brackets around the newsequentialid() - maybe that is a problem? ] table_name ( [ PERIOD FOR SYSTEM_TIME ( system_start_time_column_name , system_end_time_column_name ) ] ) [ WITH ( can be a maximum of 128 characters, except for local temporary table names (names prefixed with a single number sign (#)) that cannot exceed 116 characters.Is an expression that defines the value of a computed column.The NEWSEQUENTIALID() function is a wrapper over the Windows Uuid Create Sequential function.For example, the following script creates a new table with a GUID column as a row identifier, and a DEFAULT constraint that uses the NEWSEQUENTIALID() function.By default request data will be validated before it is converted into entities.
If any validation rules fail, the returned entity will contain errors.
It still looks bad to us as customers but as a developer I can understand.
I'm a developer who uses databases, not a database developer.
I haven't seen anyone use raw SQL to create tables since the late 90s.
My point is if you're releasing a GUI, make sure it works. The UI doesn't exactly get a lot of priority when it comes to killing bugs. The UI team doesn't exactly have a whole lot of guys on it so they get to what they can as dictated by management (if it isn't Azure at the moment it isn't getting fixed).
A computed column is a virtual column that is not physically stored in the table, unless the column is marked PERSISTED.