Is there a way to return a list of Column names, data types and if they have default values what they are?
I can get the Column names like this...
... but it would be really useful to be able also return the data types and if they have a default value or not
Figured out I can get the Column Name, Type, Nullable and Primary Key with
Just need to find a way to return the default value and I've cracked the job!
answered 19 Feb, 11:20