zzz
on Oct 15, 2015 02:42 AM
5308 Views
Hello, I have database which consists of many columns. And I have one field with default value let say the default value of that field is FOLDERNAME,
how can I can get that FOLDERNAME?
Thanks
Download FREE API for Word, Excel and PDF in ASP.Net:
Download
Andrea
on Oct 15, 2015 02:42 AM
1
zzz
on Oct 15, 2015 02:56 AM
2
Hello Andrea, sorry but it is not what I am looking for
Please refer below script
SELECT COLUMN_DEFAULT AS DefaultValue
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='TableName'
AND COLUMN_NAME = 'ColumnName'