Try to Script CREATE on table Northwind..Employees on Sybase ASE 15 [10.168.11.46]. I get the below which has an empty constraint :
CREATE TABLE dbo.Employees (
EmployeeID int IDENTITY NOT NULL,
LastName nvarchar(20) NOT NULL,
FirstName nvarchar(10) NOT NULL,
Title nvarchar(30) NULL,
TitleOfCourtesy nvarchar(25) NULL,
BirthDate datetime NULL,
HireDate datetime NULL,
Address nvarchar(60) NULL,
City nvarchar(15) NULL,
Region nvarchar(15) NULL,
PostalCode nvarchar(10) NULL,
Country nvarchar(15) NULL,
HomePhone nvarchar(24) NULL,
Extension nvarchar(4) NULL,
Photo image NULL,
Notes text NULL,
ReportsTo int NULL,
PhotoPath nvarchar(255) NULL,
CONSTRAINT PK_Employees PRIMARY KEY CLUSTERED(EmployeeID)
WITH max_rows_per_page = 0, reservepagegap = 0
)
LOCK ALLPAGES
GO
ALTER TABLE dbo.Employees
ADD CONSTRAINT UQ_multi
UNIQUE (EmployeeID, LastName, FirstName)
WITH max_rows_per_page = 0, reservepagegap = 0
GO
ALTER TABLE dbo.Employees
ADD CONSTRAINT "
GO
ALTER TABLE dbo.Employees
ADD CONSTRAINT FK_IEG_TEST
FOREIGN KEY(EmployeeID, LastName, FirstName)
REFERENCES dbo.Employees_ref(EID, LN, FN)
GO
ALTER TABLE dbo.Employees
ADD CONSTRAINT FK_Employees_Employees
FOREIGN KEY(ReportsTo)
REFERENCES dbo.Employees(EmployeeID)
GO
|
152 KB
|
53 KB
This issue is to do with special characters. On my ubuntu 12.04 machine it scripts the characters. I can't copy an paste here because it seems this editor as well cannot handle the characters in the name. will attach screenshot.
Not able to reproduce in Mac and Win. Please reopen if this still exists and is reproducible.
Not able to reproduce in Mac and Win. Please reopen if this still exists and is reproducible.
Issue #11783 |
Closed |
Won't Fix |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
This issue is to do with special characters. On my ubuntu 12.04 machine it scripts the characters. I can't copy an paste here because it seems this editor as well cannot handle the characters in the name. will attach screenshot.