|
-
Jul 25th, 2003, 04:08 PM
#1
Thread Starter
Lively Member
sql command
What is wrong with my sql command?
select Table_Name, column_name + ' ' + Upper(data_type) + ' ' +
CASE
When data_type = bigint then '4'
WHEN data_type = char then Cast(character_maximum_length As varchar(10))
ELSE 'Whatever'
END 'Columns'
from information_schema.columns
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|