CREATE TABLE inventory.products (id INTEGER PRIMARY KEY, name VARCHAR(255), description VARCHAR(512), weight DECIMAL(9,3)) ...
CASE WHEN DATA_TYPE = 'varchar' OR DATA_TYPE = 'nvarchar' THEN '(' + ltrim(str(CHARACTER_MAXImUM_LENGTH)) + ')' WHEN DATA_TYPE = 'decimal' OR DATA_TYPE = 'numeric ...