Primary key and not null
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-07-2023 01:37 AM
Hi Expert,
how we can get primary key and not null and cluster index in table creation
%Sql
create table table1 values (id int , product char)
expected output
create table table1 values (id int not null primary key, product char) and cluster index
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-07-2023 12:29 PM
it is giving error message Dataanalysisexception:table constraint are only supported in unity catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-07-2023 01:11 PM
Also tried this steps but still not working ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2023 12:24 PM
Suggestion please
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-10-2023 05:13 AM
sugggestion pls
