Quick SQL question...

[Atheus]

How do I find out what data types have been used for each column in a table? No form of 'select' that I can find gives this info.

Thanks.

 

[statik213]

if you are using mysql:
show columns from <table>;

 

[Atheus]

Thanks, that works. :thumbsup:

 

[yllus]

DESC tablename; works too.

 

[Manuwell]

what about

SELECT * FROM tab;

?

 

[Imdmn04]

Originally posted by: Manuwell
what about

SELECT * FROM tab;

?

Do not do this, if you have a large table, you will freeze up the sql box.

 

[Manuwell]

Well... my table is not that large. 4 x 6 ?