Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
Node is saved as draft in My Content >> Draft

  • Get field name, data type and size of database table

    @HIMANSHU
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 43
    Comment on it

    To get the name ,data type and size of the table we will write the following query


    We will use the SQL predefined function for it by writing a SQL query 


      SELECT columnname as 'Column Name', datatype as 'Data Type',
    charactermaximumlength as 'Max Length'
    FROM informationschema.columns
    WHERE tablename = 'student'
    SQL
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: