Luis Cazares (9/29/2015)
Do you mean something like this?
CREATE TABLE CharsTest(
myvarchar varchar(10),
myNvarchar nvarchar(10),
myLvarchar varchar(max));
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'CharsTest';
DROP TABLE CharsTest;
What it turned out I needed was the following:
SELECT CO.DATA_TYPE + '(' +
CASE CO.CHARACTER_MAXIMUM_LENGTH
WHEN -1 THEN 'max'
ELSE CAST(CO.CHARACTER_MAXIMUM_LENGTH AS varchar(4))
END + ')'
FROM INFORMATION_SCHEMA.COLUMNS AS CO;
I was just not finding any one field that had the datatype exactly as it appears when you look at the table columns in SSMS.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)